A Dumb Question
Aug 21, 2007Every time I use the build tool in a query my quotes do not display correctly so my formulas do not work. When I type a quote it appears slanted like italics. It is an inconvenience. Anyone seen this before?
thanks
ADVERTISEMENT
Dumb Question.....
Jun 15, 2006Ok, I've spent about 3 hours building my table, and now want to actually use it ;). I think I can do everything except this one thing. Which I could probably write a whole bunch of unneeded VB code to do it, but hopefully you guys can provide a better answer.
Ok, my table has 326 records. Each record has a field with a dos command in it. So 326 dos commands total. In my form, I want to create a command button that will launch the dos command I have listed in the field of the current record.
i.e. record 1: blahblah1.exe, record 2: blahblah2.exe. If I'm viewing record 1, I want to launch blahblah1.exe, record 2, blahblah2.exe so on and so forth.
There's probably an extremely easy way to do this, but I don't use access much and have never really learned. Any help would be greatly appreciated. :)
GI_Mike25
Dumb Question Again.
Dec 3, 2004Can a database be made into an .exe that will work without access being installed on a computer.
View 2 Replies View RelatedDumb Question Of The Week - Error Handling
Apr 26, 2007Do you folks include error handling in every single procedure?
Even on a "Quit" button with DoCmd.Quit behind it's OnClick event?
Possibly Simple, Possibly Dumb Question.
Sep 10, 2006I've developed a database for a small company but've now encountered a few problems. Initially, I was asked to create a table of customers and a table for business to business trade. However, I was then asked to merge the two tables together.
This led to a problem. The primary key was set to adhere with the already existing ID numbers of customers which were created by the company director years ago before the leap in to technology. For example, their first customer had an ID number of 1 outside of the database, and thus in the database the first customer would have an ID number of 1. This is simple, and could be achieved with an autonumber.
Outside of the database, ID numbers were created chronologically, so the first business to business trade did not have an ID number of 1, more something like 321. As I said a while back, the two tables had to be merged, and this left me with every customer in the first ~1000 and then all the B2B trade lumped on at the end. The question I'm thus asking is there anyway I can reorder the records selectively to retain their original ID number? It'd save the director a bunch of time.
Thanks in advance, David.