Search results

Thanks, is vba code the only option here? can you please explain how the code works, whre to insert it etc.? TIA,

Greetings, I created a blank form ‘frm_CASES_All’ and added a button to open my report ‘rpt_CASES_All ‘ which is based on my query ‘qry_CASES_All’ On the form I used the following for my button to open the report DoCmd.OpenReport " rpt_CASES_All ", acViewPreview However, my goal is to use...

cJ_London, I just tried the modified code in my test environment. When the login form appears, I clicked 'Logon' (without entering my credentials) and it lets me in to the main menu. TIA,

cJ_London, Thank you. I made the changes and included in the complete code below: Option Compare Database Public gblUserNm As String Private Sub cmdClose_Click() 'Close The Login and Close Database Once Cancel It Clicked On Error GoTo err_cmdClose_Click DoCmd.Quit Exit_cmdClose_Click...

Thanks, CJ_London, I uncommented and moved the code below the OpenForm DoCmd.OpenForm "frmMainMenu" Private Sub cmdLOGIN_Click() 'Enable certain options on the main menu screen depending on access level If Me.txtPWD Like "SU*" Then Forms!frmMainMenu!optMaintenance.Enabled = False...

Thank you for the reply post re: Possibly because if you uncommented it, the form is not open so you get an error. Does this mean even if I uncomment it’s going to throw an error? re: Move the code to below the openform line Below the last OpenForm in the code below? DoCmd.OpenForm...

Thanks CJ_London Sorry I didn't reply to your previous questions as I was not at work. 1. re: open form in design mode > Right click combo > Properties > Data Tab > Rowsource Control Source: blank Row Source: P: Providers or C: Clients Row Source Type: Value List re: Also...

Gasman/CJ_London Thank you all for the feedback. The issue is we have over 72k records. I’ll adopt the resource provided by Allen Browne below Maximum records for combobox recordsource and post back if I have any questions. Regards,

CJ_London, Thank you for the reply post. re: what is the sql used to populate your list? a. The database was designed by someone else. Where do I look to get this info? b. When looking at the table, there are over 72000 records. Can this be a limit issue that a combo box can...

Greetings, We’re currently running access 2016 split database (with individual front-end and shared back-end) Couple of questions: 1. We have a form with a drop-down whereby users select either P: Providers or C: Clients to populate the name of the provider or the client. However, the...

I’m not sure if the following test I performed give us any lead to the cause(s) of this issue: 1. I can run the report fine from my computer without any problem 2. When I’ve the managers who are unable to run the report come to my desk and log in to ms access using their own credentials, the...

The_Doc_Man , thank you for your reply post. re: Can you run the report from THEIR computer? No, I just logged in as myself and was unable to run the report re: Is this a split database with individual front-end and shared back-end. Yes, it is a split database TIA Regards,

Greetings, I just started supporting ms access 2916 db that was created by someone else. A report was created for managers whereby they run ‘open case report’. The issue I’m encountering is that managers can access the report, they will be prompted to enter a name, managers enter...

Yes, based on your inputs, I was able to complete the rest and hide those unwanted columns. Thank you for your help. Regards,

Brian, Thanks for your input. For my vendor rpt. following are only columns that I’d like to filter out and what columns are going where: Column A (Order number) no change Column E (Order date) goes in column B Column L (Supplier) goes in column C Column X (Account code) goes in column D...

Hi, Given the attached sample report 1. I would like to filter only the needed columns that are highlighted (Columns: A, E, F, H, L, W & X) 2.rearrange and list columns the same as Order Rpt (below) A = Order Number B = Order Date C= Supplier D= Account Code E= Blanket Order F= Order...

Greetings, I start creating the attached access db to simplify the data entry process currently done using Excel. We also purchased a third party application (for data definition purposes) that allows us to import what we already have in place. But, in order to export to the third party...

Greetings, We use Excel 2010 to input detailed information about a given data element and use save as CSV to export to a third party application that we use for data definition purposes The third party application allows us to import a CSV template limited to 10 fields (A – J). Since we...

Thank you NBVC for your reply. I was able to sort out my problem: I wasn’t sure why 0 was returned for cell H and was because there was a match in P but, corresponding cell W is empty You were right the result = #N/A, when there is no match at all. Thanks again. D.

Thank you, I've attached the strip version of the excel wb. Regards, D.