Search results

try whacking in a 'Do Events' I think it is just before your docmd.sendobject

hm, try the following; set filters on the query and export those one by one to workbooks or separate sheets in the same workbook if you desire also probably worth setting a function to rst.recordcount by group to work out how many filtered queries you'll need to export to xls

Hm may sound silly but maybe a reference issue? Have you tried the ol latebinding route to see if that has any luck with your little hurdle? Probably take some digging in the object browser but may work?

You are checking to see if the textbox is null not an empty string? Perhaps change this line here; If IsNull(Me![PCNumberIn]) Then to If IsNull(Me![PCNumberIn]) or Me![PcNumberIn] = "" Then ' this will check for the value of an empty string (which your clear is setting it to) and halt the...

You could import it to a tmp table like impSpreadsheet then with your button 'on click' import the file to tmp, then just move the data from row 8 or whichever row you need into the the designated table? Once the move's successful delete the imp table as it's no longer needed?

Can you not get the password? It would seem illogical to password a database if it could be circumvented that easily no?

could you not try .visible = true or appactivate or something similar? I remember having a similar sort of issue with word automation on 2013 which was something to do with the filetypes HTH! If you do find the solution please post !

Hi Perhaps something like.... If Dlookup("empUsername", "tblUsers", "empUsername =" & txtUsernamevaluehere & "") Is Not Null Then ' check username matches If Dlookup(same as above but for the checkbox) = True Then Load frm Admin ' so this point username matches...

On your query you can do something like Cardnumber: Iif(checkbox = checked, cardnumber, "11111111") This should put you on the right path - good luck and let me know if you get stuck :)!

Hi I use the following to get the ID for the right calendar to add appts to; Dim olfolder As Outlook.MAPIFolder Dim olapp As Outlook.Application Set olapp = CreateObject("Outlook.Application") Set olfolder = olapp.GetNamespace("MAPI").PickFolder then you can print olFolder.entryID...

Hi Could you not have a small form where the user can enter which article(s) and the no of times to print and just loop the above code through each label to print them?

Thank you to all contributing here, I recently started a java OOP course and had NO idea I could do all these cool things in Access too...! Some questions however if I may.. Is it more efficient to base forms for data entry around classes that we can write the values of to the table with a...

Hi Can you please post a copy or ss of the form you are referring to - been a long day struggling to visualise this!!! Does the user not have the option to set the status for problems??

Hi all Been a while since I have posted here but this has had me at my wits end and I can not figure out why. I've searched for ages on google and here and haven't found an answer - I am rather tired and I am hoping it's something so simple I will be able to laugh at it in the morning. The...

to carry on as you are you could just DoCmd.SetWarning False DoCmd.DeleteObject tblhere DoCmd.OpenQuery 1st query ^^ 2nd query ^^ 3rd query ^^ 4th query DoCmd.SetWarnings True But as stated above it may be worth looking into...

The easiest way I found to set up mailmerges is to set up the word document that links to the database then in VBA just set that to open the word document (making sure all alerts are on) then you could saveas the file where it needs to be with VBA HTH if you need more input or some help on...

Try; forms![FormA]![SubFormC].Form.Requery Or something along those lines! Let me know if this works!

The easiest way to do it in my mind is how JHB suggests, or you could specify which columns to pull from the query to excel based on which ones are hidden but that sounds like much more work than is needed. Do you currently have a sample of what you're working with (the code)?

t1disc and t2disc aren't percentages they're values - set up that way so it's faster for people to answer queries I think on the phone. I put the Nz in the query as you suggested and it's working as intended, so thank you very much for pointing me in the right direction with your know how...

Hey Ok I have the code in how I think I'd want it - I Nz'd everything to give it a 0 value incase something comes back null to stop that cocking things up if it would, but in the query it's returning #error. Would this be because of the function types or would it be something with the code...