Search results

I will check both of those out. Thanks!

Hello AWF, Does anyone have any experience or code with searching all database objects for a sql string? I've started looking at how to approach this over the last few days and haven't come up with much.. Other than the export to text and then search through text files. Basically - I've...

You can also call a function. I run through a number of tables with this below that gets called when running a daily update procedure each day. Function removeold() Dim db As DAO.Database Dim strSQL As String Set db = CurrentDb() 'removed tblRecords > 5 yrs old strSQL = "DELETE tblRecords.*...

Thanks for the suggestion. Unfortunately it didn't fix the issue. I had a recordsource that had form control references.. I changed them to variables in VBA and set my recordsource with a sql string, and now is working okay. 🤦‍♂️ silly me.

Hello AWF, I'm having a problem with a text box value not updating as the form record source is being updated. This was working fine with an Access back end, but now that I have migrated to sql server it does not. The attached sample database is my attempt to simply explain the problem. User...

I use a scanner in a few of my databases with the InputBox function. Private Sub emp_Click() Dim inbox As String Dim trainee As LongPtr Set db = CurrentDb() inbox = InputBox("Trainee please scan your badge") If inbox = "" Then DoCmd.Close Exit Sub End If trainee = CLngPtr(inbox)...

Valheim is a great one that I stumbled across recently.

Removing the acExportQualityScreen also produces the same results as before on the trouble PC. Private Sub cmd_excel_Click() Dim reportName As String reportName = Forms!frmPCDsingle!pcd & ".pdf" DoCmd.OutputTo acOutputReport, "rptPCDtoPDFAllZone", acFormatPDF, reportName, True End Sub

So I have got a little closer.. On my PC this combobox still works fine and on load contains a selected value. The other pc's did not see any value selected or any values in the combobox dropdown. I changed the form_load event to set the rowsource for the combobox, and instead of using...

Yes they are also using the dsn-less connection and can see the table data. the txt_user is a textbox on the start form that is populated in the form_load event.

Multiple users do use the same physical office printer when printing hard copies - but only one of the users that share the printer is having this spillover problem. There doesn't seem to be adjustable dpi settings in the printer properties.

It is a laptop that moves between two workstations connecting to a TV or two external monitors. The problem remains when using either setup, and also when only using the laptop with no external monitors.

Hello, I am facing a problem with a combobox on the start form of one of our db's after sql server migration. When doing a debug.print the correct values are returned in the form_load procedure, but this combobox stays blank. I've added a requery on the combobox in the form_load procedure, but...

I did verify this morning that the trouble user's PC also has Microsoft Print to PDF set as default. I need to reach out to IT about reinstalling/updating the driver. Thanks for your input. I had them try 2 versions of the db also - 1 with the report set as use specific printer and selected...

I have not. We are using Microsoft Print to PDF. Sounds like that needs to be the next thing that I do then. Thanks

Hello AWF, I've spent the last two days trying to figure this out and am not having a good time. I have a report that is sent to a PDF file which has been working well, but one of the users is getting spillover on the report and it is adding extra pages. For other users it is working okay. I've...

I would have a payments table that stores all payments made. If the fee is $35 and they paid $1 dollar 35 times with different payments, then there would be 35 records in the payments table that would be summed up and compared to the fee amount.

Hello AWF, Can anyone share a preferred method of concurrency testing? I've migrated Access BE's to sql server and made modifications, optimizations, configured data types, set up views in sql server, etc, and the speed/performance seems great so far. I now need to test multiple users using the...

Sweet. Will this process the filter in SQL server or will it send all of the data in the view to my local access FE and then apply the filter? That is what I meant with "best way" - I should really start drinking coffee again.

Thank you - the pass through query sounds like what I need. The terminology will help me dig into this some more.