Hello all, it's been a while - I ALMOST forgot how great this site is!
I am creating a basic data entry form. What's not so basic is this: I would like a field that will automatically insert a certain number of records. For example, I am tracking defective products. Sometimes I may get a batch...
Yes, I am importing this data into an existing empty table with headers in place. The field has a 255 limit and has the datatype text. As for a validation rule, I am not so sure...but I do not think so.
Hello...
My job requires importing tab and comma delimited text files into Microsoft Access. Often, some of the fields contain overseas phone numbers. Here's an example:
+45-22-917-1234
Access seems to be purging out the "+45-"; this is what gets imported:
22-917-1234
This does not happen...
I have created a query to display certain records from a database, and sort them. I want to be able copy these records from this query and OVERWRITE the records in the original DB. I want to effectively move these queried records to the top of the original DB. However, PASTE APPEND is not...
Thank you for your help...this site has the quickest and highest quality responses anywhere BY FAR. People here really understand the significance of an online community.
Dan
That did not seem to work. It asks me for the value of "name2", which I assume it means that it is not accepting the "AS" statement. Hmmm...thanks for your help.
Dan
I am sure I have seen an applicable solution to my problem, but I cannot find it in the threads. Here's an example of my database:
Name1 Name2 Path
----- ----- ----
Bob Reel \directory\bob.jpg
Bob Hill \directory\bob.jpg
Fred Sadd \directory\fred.jpg
Fred Pudd...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.