Search results

Awesome. So this means I wont have to go through and add a line to every instance where I used CurrentDb. Is this a run-once solution, or does it need to be run on DB open? Thanks

Ok, thanks for the reply. Sorry if this was in the wrong place, but I was working with VBA, so I figured Macros would be the right place. You were correct. The where statement does need to be formatted for access, not SQL server. So that was half the problem. The other half was discovering...

I'm having trouble opening recordsets with my linked tables. When everything was stored locally, all my queries worked fine. The problem arose when I migrated the back end to a SQL server. When I try to run the following, the code just kind of dead ends at the OpenRecordset line. I don't get...

Ok, you are probably right. A subform is probably a better solution for this particular case. I have no idea why I didn't consider that. However, I'd still like an answer to the question, if possible. The reason is, I have dealt with this before (wanting to have the same code in multiple...

My form has about 20 rows of comboboxes and text boxes. On loading, it only shows the first one. When the data is complete for that row, a control appears that allows the user to "add a line". This actually will just unhide the next row, and populate the control/row sources. I wanted to make...

awesome. I figured it would be something simple like that. I appreciate it!

bump Either I am asking a very stupid question, or a very difficult question. Please advise.

I have an Access form with an Excel Spreadsheet as an OLE objects. I have a macro that populates data automatically. It works fine, unless the PC has an open Excel window. If excel is open, the macro will send the information to the open sheet, rather than the object. Can anybody explain...