Search results

I am using MS Acccess 2019 and I need to amend the SQL string of a linked table so that it points to another database. Can this be done without having to physically go and link the table again? I thought previous version of Access had an 'Edit' button on the Linked table manager but this is not...

Thanks Both, I will have a look at both of these options.

Thank you but then how do I retrieve the values that have been selected in the box. I need to use a query to generate the report so am thinking I need to use a parameter to retrieve them.

I need to create a bespoke reporting tool that will allow the user to select multiple options from a combo box but want to avoid using the built in multi valued field. I have a record set with an ID, a status and various other pieces of information (such as date created, created by, quote value...

Yah Ive just managed to do this myself :) DoCmd.OpenForm "sfrm_Report_Detail", acFormDS, , "[Status]= '" & Me![Status] & "' AND [Table]= '" & Me![Table] & "'AND [Type]= '" & Me![Type] & "'", , acDialog

I have a piece of VBA code that opens a form and filters the results with a two column criteria, which works perfectly. DoCmd.OpenForm "sfrm_Report_Detail", acFormDS, , "[Status]= '" & Me![Status] & "' AND [Table]= '" & Me![Table] & "'", , acDialog However I need to add a third filter...

No I hadnt spotted that but I have it all working now thank you and its all down to you that the system runs so much faster now.

I see what you have done, thanks. I have change the system to use the vba browse to code that arnelgp provided but thanks for pointing out the error.

Thanks for your reply. I appreciate what you are saying about changing the application not to use the navigation forms but unfortunately the system is so big that I couldnt possible change it all now. The project is pretty much completed and its been 2 years in the making (on and off doing other...

OMG that is so simple. I cant believe it works. I did originally try to do the browse to in vba but couldnt get it to work. I will change all of my browse to macros for the other tabs to your vba method. Hopefully I can get everything to work OK now.

I have built an application using Access inbuilt tabbed navigation forms. I am not able to change the system not to use the built in nav forms now because the system is way too far along for that and very complex. I have several tabs within my navigation form. The Home tab contains a subform...

Great idea but I do not have the skills to write the code to do that. Are you able to help me please?

I think I have found the issue but not sorted it out. The reason for the error is that I have two SQL databases linked to the application and I need to check tables from both SQL databases. I am not sure how I can do this so if anyone has any suggestions I will be most grateful. Thanks

Yes because when there are changes made to the sql tables they are not reflected in the Access application until the tables are refreshed. There will be several people using their own copy of the app that so it makes sense to automatically do it everytime the app opens otherwise I will need to...

No I have only renamed in Access so the linked table is still named with the dbo_ part but I have removed that in Access as you can call the linked tables whatever you like which is what I did so that my existing application continues to work otherwise I would have to change a load of queries...

I have a function that is called when my application is launched, and it relinks my SQL tables. Which was working perfectly well until I move some local Access tables into SQL and then had to renamed them in order for the application to continue working. For example I had a local backend...

Time is not on my side as needs to be done on Monday next week. I have to leave my main tables in Access because there are multi valued fields (dont scream at me, I cant change it now (or at least dont know how to). I know what the real issue is. Its having over hundred combo boxes on a single...

Thank you I will have a read and hopefully gain more of an understanding. Its my boss that has told me to move it SQL as its so slow in Access but I am not convinced it will speed things up.

I have an Access application that is linked to some tables in an existing SQL database plus another 148 local tables in a separate backend Access databasae. I would like to move the backend Access tables to the SQL database and then link them back to my application in the hope that the SQL...

perfect thank you. I have changed it to round to 4 decimal places.