Search results

Hello AWF, What is the best way to pass a hidden text box value to a sql server view? I have a hidden text box on one of my forms that holds the department an employee belongs to. This is how I have done it in access. SELECT tblEmployees.emp_id, tblEmployees.department FROM tblEmployees WHERE...

You could put the code in the form_load() event and call that form to be the starting display form under options -> current db -> display form

Understood - I wasn't sure if the troubled module was only the ELookup function. I tried to replicate by going to the AB website (http://allenbrowne.com/ser-42.html) and copying the module myself, and I get a VBA compile error message from it. (Compile error: Constant expression required) You...

If you hold down shift when opening the db does it let you open the VBA window? And if so could you then open and post the module code here?

Have you tried a decompile? http://www.fmsinc.com/microsoftaccess/performance/decompile.asp I see in post #3 mentioning decompiled after linking images but in post #4 it says no access to decompile from citrix. You should just be able to paste the msaccess.exe path with /decompile in your...

This only returns 0 or 1, so sum and count produce the same results. Count(IIf([tr_date] Is Null And [str_date]<[tblHS_area_fields]![aud_date],1)) AS notrain

i'm checking this out now. Thanks!

I have not used the jet show plan. Let me see if I can dig into that. The 2nd join to tblEmployees is to bring up the count of all employees. The sum vs count gives the same results also but does runs a few ms quicker. Test Addition Unit Average Minimum Maximum 1 2 3 4 5 6 7 8 9 10...

Hello AWF, I'm trying to optimize multiple queries such as this one below. Does anything jump out that would help optimize this? I've been using the link below and identified my problem queries that take the longest. I'd like to approach this to achieve the quickest possible query run time...

My skull is really quite thick. To clarify what I'm asking - I was wondering if the persistent connection code should be removed from Access FE's when migrating to SQL server BE's, and it sounds like it probably should. Is anything else I should also add to my "BE Access to SQL server...

So - is there any reason to use ADO over DAO for certain things? Also, when converting backend to SQL server, are there certain procedures that should be taken out of front end db such as persistent connection with vba & hidden forms?

I thought that was what the post was asking.. And someone said they didnt have access to chatgpt to produce the response. In no way do i endorse or think it is correct, to be honest, I'm not good enough to deduce that, but I thought that was the purpose of the thread..\ And yeah i just checked...

Wow, for some reason I thought I had read many many times to convert DAO to ADO when migrating to SQL server. I have dodged a bullet, because I do not like ADO at all. Very good input from everyone, thanks. @Pat Hartman thank you again for your guidance. I have some optimizations to do. I...

Does anyone have any good references for converting DAO to ADO by example? One thing I have really struggled with is finding a good reference source to convert my DAO to ADO. I know queries need to be optimized, and views implemented where possible, etc.. That is about the extent of my...

Arnel, I did not, but appreciate your suggestion. Can you explain the difference between? DoCmd.OpenForm FormName:="frmHS_pdca" and DoCmd.OpenForm "frmHS_pdca" I will implement in a test db and see if it produces any effect. Looking at microsoft docs I do not see the FormName included in...

Pat - thank you for sharing your previous experience with me.. I will test that out when I get back in the office on Monday. I thought I'd hear it was corruption issues, but the fact that you have dealt with this previously and were able to work around it gives me hope. That was my first thought...

One more: Could you produce a much more complex example of how to programmatically create a continuous form in access with using visual basic for applications code? Sure, here's a much more complex example of how you can programmatically create a continuous form in Microsoft Access using VBA...

here's a more complex example (PER CHATGPT) of how you can programmatically create a continuous form in Microsoft Access using VBA code: vbnet Sub CreateContinuousForm() 'Declare the variables Dim frm As Form Dim tbl As TableDef Dim ctl As Control 'Create a new form Set frm = CreateForm 'Set...

CHATGPT ANSWER: Unfortunately, Microsoft Access does not have a code-based method for creating continuous forms. Instead, it provides a visual interface for designing and creating forms, which can be done through the steps outlined in my previous answer. However, if you need to programmatically...

Thanks for confirming. Just wanted to make sure!