Search results for query: *

You know why I hate my job? It isn't until after I get frustrated, after I scour the web for a solution, and finally after I spend a half hour writing a post for this forum, do I finally figure it out myself. I don't really hate my job though, it keeps my mind sharp :) Turns out running a...

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...

what i'm trying to do is to create a new insurance application based on a recent year's application, using much of the same data. the first combo box selects the vessel, which could have any number of years' applications, up to, but not necessarily including the current year. each time the...

that gets me partway there, i think. but the problem is that the the dates won't necessarily be consecutive up to current (the idea is actually to pick the most recent year). it could potentially go 2000, 2001, 2003 or 2000, 2001, 2002. in each case, i would want to select the most recent. i...

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...

aah. i figured it out with the help file (that thing is too useful for its own good). i ended up using the DLookup method. very useful and quick for picking up a single value from a table or query. here is the line of code for anyone interested (strName had already been assigned a string from...

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...