Search results

are you using access to design your query instead of writing your own SQL code? If you are, set the criteria under the intended field to forms!xyz!textbox1 or forms!xyz!textbox1 = null So if you want to query for first name and last name: 1. insert two text boxes in the filter form, i'll call...

No. But I can get it. I meant really, just in general how you got it done. I'm not very good with codes, so just want to get a general idea on what is the way to go first, what are the methods available to get this done. My users are quite computer illiterate, I have to make things really easy...

Whatever criteria you used to open the report from the switch board can do the same, but here's an easier way: 1. put in a textbox into the pop up form, name it "reportName", and make it invisible. 2. add these lines into each report's on open event: DoCmd.OpenForm "frmPrintEmailPopup"...

Try search for keyword "find file" or something like that, there was a post here that helped a lot. Separately, I have here a sample database I created for capturing image with PC cam, and viewing it in Access. The code is somewhat messy, you'll have to change the directory and play with it to...

Seems to me you're giving yourself a hard time for nothing. First of all, I think you haven't specify the report correctly. If you have ten reports to choose from, maybe If function, or select case, would be more appropriate. So if there's something in the pop up form itself, or another form...

Was there some resource you use, or a sample you can show us? I'm trying to do something similar to this but only with outlook, and with just one function, receiving an email that contains a html table and either save that table in a specific folder or append it directly to an access table. Any...

Any tips to share? I'm trying to create a button for receiving and another for sending email from access, and I'm starting from scratch - meaning I have no clue what code to use or what's available out there. Would appreciate some pointers.

To print the report when it's opened it's: docmd.openreport "ReportXYZ" acNormal allows you to view it as per normal, acPreview lets you see Print Preview etc Have no idea what the code is for email, searching for it too. Any suggestion, helpful people? :D

Thanks. For future reference to anyone as clueless as me: Kill ("path to the file you want to delete here") will delete the file. To get the paths to all the file you want from a folder: Dir ("path to the folder here") use some kind of filter to single out a file you want to use.

Hi, I'm trying to delete all the files from a folder once I've copied it to another location. Now stuck at trying to find a code to do the deletion. Tried deleteFile function, also object.delete, something like this: dim myObject as object set myObject=me.path 'path contains the...

Delete the link table and then re-create it again? I use access 2007, that's what I always do when I have problems relinking.

Tried that. I thought it might be the .inf file that is stored in the flash drive, but it won't save any changes that I make to the file. Perhaps it's locked or something, and someone knows a way to unlock it? What kind of programme do people use for the kind of automatic start ups in set up...

Thanks alot Mike. Looking into it. Seems like it might do the job. Does anyone know of any VB code or method to initialise a programme from window when the flash drive is plugged in?

Here's my situation: I have two work stations which I can't connect by a network, location too far apart, internet's not an option currently, but I want to share the data that's entered at the factory with the users at the office. I'm thinking of extracting the back end copy of my database...

I think CraigDophin is right, it's how I would do it too. Pavlos, unless there's something complicated about the "calculation based on each client's profile" you alluded to, you shouldn't need a relationship because there's no relationship between them that I can see. If there's a field in your...

You can do it as pbaldy suggest, or what I have done is to combine the product and door style into one unique productID, so if you have 158 product lines, and 8 door styles, that would mean 1264 products. You can configure your productID such that it contains the information from your product...

Why would you want to do that? Wouldn't it be better to do everything in Access? It already has most of the functions that Excel has.

If you want to see all the previous record as well as go to a new record, you should try irish634's suggestion: DoCmd.GoToRecord acForm, "YourFormNameHere", acNewRec in the form's onOpen event.

From what I can see, your first if block, for the second if, it should be: elseIf StdResponse = 6 Then and you seem to have an extra end if, whether you want it just before the end sub or before exit sub, I don't know. Have you put it in the code window and see? Access should have picked out...

And here's my bit about hiding and showing navigation pane using codes: To hide the pane use: DoCmd.RunCommand acCmdWindowHide To Show the pane: DoCmd.SelectObject acTable, , True Both worked well for me. Convenient to use with a button so that only I can look at the tables when I want.