Search results

Well this seems to be working. Had to fix a couple of names that somehow got lost in the translation... Going to test it a bit to make sure before implementing. Thanks for the help!! This is what seems to have solved the problem Mobile...

the table name is called tblContacts Here is the full sql for that query. This is working fine when I changed the name to "Mobil" Just can't get it work as "Mobile" since it's the same name as in the table. SELECT tblCompany.CompanyName AS Company, tblContacts.ContactName AS [Contact Name]...

Not sure where to put this. Can't get it to work in the query

I was hoping there was another way...:(

I have two fields. One called "Mobile" and another called "PersonalCellular" I'm trying to write a query where if the Mobile field is empty, it would be populated with the PersonalCellular field. So I tried this, Mobile: IIf(IsNull([Mobile]),[PersonalCellular],[Mobile]) This results in an...

Thanks - I didn't notice the sample database links at the bottom of that article. Looks a little complicated for what it ultimately does, but at least I can see that it can be done. I'll have to set aside some time when it's not too busy to try and adapt the method. Thanks again and have a...

Thanks - that was fast. This seems to be what I'm looking to do, but there are no sample databases that actually shows it in action. I can crate a small one for testing, but it would be great if there was one readily available. I'm using access 2010.

I have a continuous form showing a set of records. There is DoubleClick event on the record number, which will open a single form for that particular record. When you close that single form, the continuous form is shown again – all is good. In the single form, there is a field that users can...

Well it looks like it happened again and I made sure that Excel was definitely closed and no excel processors were running in the background for all users. This time, I tried a few things before resorting to a backup. What seems to have worked was to actually save the spreadsheet before...

Thanks - I'll look for that the next time. I managed to "sort of" duplicate the problem by having the spreadsheet opened before exporting. And as expected, the spreadsheet did not update. But I'm pretty sure Excel was closed when I was actually having the problem. Next time, I'll verify by...

I'm using this code to transfer data in from a query to an excel .xlsx spreadsheet DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, WbSheet, CurrentProject.Path & "\" & WbName, True This works over 95 percent of the time. But sometimes, for some reason, the spreadsheet does...

Well after a little google searching, I found a way of doing this using the KeyDown event. solution found here: http://www.vbforums.com/showthread.php?367165-VB6-Using-the-KeyDown-Event For anyone interested, here is how you do it. Private Sub Form_KeyDown(KeyCode As Integer, Shift As...

Well Form_Error event didn't work either. I believe that Access has the "Escape" keyboard button built in so that it always tries to perform a "Cancel / Undo" event. So there isn't anywhere in my code that is triggering it.

Where do I put this error handling? I tried putting it in the form On Current event, but still getting the error.

I have a continuous form that I'm using with various filters. There is a command button to filter the form based on what the user selects in a few combo boxes. The "Apply Filter" command button is the default so when the user presses "Enter" on the keyboard, the form gets filtered. There is...

Thanks - that was it. I guess I wast thinking more complicated than it really was. Even seems to work fine if I remove the record source. Not sure why though. Still testing....

OK - well here is what I have so which works fine for filtering the first subform called "subFormAttachmentQuickLinks" on the main form '---------------- Me.RecordSource = "SELECT * from tblAttachmentsQuickLinks; " '------------------- strWhere = "" 'Document Name Filter If Not...

I have a main form with three un-related subforms. Each subform shows data from its specific table. Is there a way to create a single unassigned text box filter on the main form that will filter each of the subforms at the same time?

When using Google, you could add move words to narrow the search down even further. For instance, if you put this in a Google search: access vba .Execute "using quotes" About 72 results (0.43 seconds) In fact, this thread shows up 5th from the top in a Google search. That's pretty good...

Just wanted to respond to your suggestion about searching in this forum. Over the years of searching for specific information in this forum, I've come to realize that I had better results from searching the internet with Google. Consequently, I have to admit that I don't use the search feature...