First a little background, hopefully I can communicate the big picture here.
I have a MSDE database running on a dedicated database server, and am using a series of Access forms as the front end.
The tables are linked to the MSDE database by way of ODBC.
I am using a third-party database...
On my current project, my program does a lot of checking whether or not there are any records returned from several different SELECT queries. My question is, should I be dumping the query into an ADO recordset and checking if the .count property is greater than 0, or should I just continue to...
I have several different csv price grids for my company's product. For example, the files might look something like this:
0,6,12,18,24,30
12,100,120,140,160,180
24,200,220,240,260,280
36,300,320,340,360,380
Despite concern that I may muddy the waters a bit by explaining it, the top row and...
i have several reports that need to be printed on 3.5"x1" labels for production on the factory floor. i've set up a new form size in the printer driver as the correct size for the labels, and set the top margin to 0.0in, the left to .25in, the right and bottom to 0.0in. again i did that in the...
I have a two comboboxes on a form. The first selects the name of a vessel in the database, and the second selects the policy year (insurance) for that vessel.
each vessel has a different history of policies. i've managed to get the term combo box choices to list all the items i want, with it...
here's my situation:
I'm looking to snag a field out of a record retrieved by a command executed by the doCmd.RunSQL method or something and then store it in a variable.
this query will only pull one record and i want a single piece of data out of it. any suggestions?
the table structure...
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.