Sequential Numbering That worked -Thanks Marshall Barton wrote: rs.SerialNum = Serial & "-" & Format(Qty, "000") BUT! You should not combine two values into a single field (it's a Normaliation Rule). Instead, you shoud use two fields, one for the serial string and another for the sequential number. Also helpful if you s... 9 Mar 2010 00:15
new messenger Friends and friends around the world. We are presenting the new messenger. He will be in the commissioning by the friends that we indicate to use the system. Access the system by clicking the link below and register free. You get something for using orkut? You get something for using skype? You gain something... 8 Mar 2010 16:26
Change paths to linked external data Hello. I have a database that has 3 external links in it: 1 is to a table in another Access Database. One is to an excel spread sheet. And, the third is to a .csv file. Is there a way in VBA to change the paths to these? Basically, i want to set up a form where the user can specify the new paths in text b... 8 Mar 2010 18:43
Missing Operator I am using Access 2002. I have a listbox with two columns that allows me to choose one or more items, then generates a report for those I've chosen. I am receiving an error on some of them. It is: Syntax error (missing operator) in query expression '([txtCourseTitle] = 'Career Edge Director's Program' And [... 8 Mar 2010 14:10
SELECT FROM Query name I am using a SELECT statement as a rowsource on a form listbox. I have a query named 01-Accounts Query and the SELECT stmt reads as follows... SELECT 01-Accounts_Query.Name, 01-Accounts_Query.Date FROM 01-Accounts_Query I get a syntax error in query message. How do I fix this? ... 8 Mar 2010 13:04
Detecting a Character I'm looking for a simple way to check that the text entered into a text box contains a slash at the end. I'm assuming VBA that executes On_Exit. -- Peter Marshall Manager Information Services Ohio Coatings Company ... 8 Mar 2010 09:42
Geting travel distance from a map - add-in Hello, I have a user who goes into the Internet using Bing map or Google map to get sales person driving miles from point A to point B. My user inputs in separate fileds the From/To Address, City, State, Zip Code. The mileages is all calculated in a report. We are using Access 2003. The problem is there a... 8 Mar 2010 11:57
Detail in form goes blank Thanks for reading this. I have a sub form that I use for a search box and when I type in a dummy name to check if the search is correct, the detail section blanks out. Of course, when I type in the correct name it is ok. I'm just wondering how I can keep the screen in the detail section on. I do have: Allow Ad... 8 Mar 2010 14:10
VBA Code Written Once For All My Forms I have a couple procedures that I use for dozens of forms in teh same database. The code for this prodecure is identical. It's not in every form, but many. Can I reference such a procedure from any form I want, but write the procedure once? ... 6 Mar 2010 20:41
Preparing a Access Database for a Website Preparing a database for the Internet website: Whether it's php, asp, or PERL or any other odbc language, the database should be prepared, right? I mean encryption, etc. Is the database editable while it is encrypted? ... 6 Mar 2010 20:41 |