Search results

Hello, I've got what looks like quite the issue with my database, and I'm mystified as to what could be going on. I've got a database used daily by 4 users. It's split into a frontend (10MB) with all the forms/queries/reports/vba and a backend that's just tables (170MB), and the users access the...

I'm used to seeing runtime error 91 ("Object variable or With block variable not set") when I try to say var = object instead of set var = object however, the following code uses set, and the error only occurs when I try to exit the function: ' Find a control for the given string name Private...

I know that I can access the data on a subform using syntax like me.subform.form.field What I'm trying to do now, is to write a function that will take the field name as a string and do the logical equivalent of: private function getField (field as String) dim ctl as control For Each...

Hello, I have a database that is currently used by office-employees of a company to track the services that their technicians perform at customers' sites. It is an access database with all of the forms coded from within an Access 2007 frontend (mdb), with a separate access backend (.mdb). All...

Hello, I have a form with a subform in datasheet mode. I would like to perform an action when the user clicks on the row-selector/row-header column (see screenshot). I am currently using the form's onClick action, but that has the annoying property of getting triggered when I click on a...

I have a report that I've built, and I'd like to be able to fax it without user-interaction. The only hardware I have available to me is an all-in-one fax that has print-to-fax capabilities. When you print to it, you get a screen which allows you to enter recipients, and then send the fax...

Hello, I have a form with the recordSource set to a query that would give me a set of contact information. What I would like to be able to do is to iterate through that query, and access the attributes of each tupple. Do I somehow have access to the data contained in the query by nature of it...

Hello, I've got a table that looks something like this: deviceID | name | ... 1 | a 2 | b 3 | c 4 | d 6 | e where deviceID is an autonumber. Clearly device 5 got deleted, but if I go to "add record" I end up adding record 7. There...

Hello, I'm currently trying to add some lines to a form just to visually separate various elements. Unfortunately, they just don't show up when I run the report even though they're very clearly there in the design view. The same thing happened with all of my field labels (although I fixed that...

Hello, I'm working with SQL and databases in general for the first time, and was wondering: how would I select just the most recent entry for each device? my data looks [roughly] like this: device1 data_1a 15.2.2000 device1 data_1b 15.2.2001 device1 data_1c 15.2.2002...