Search results

Hello All, Is it possible to generate a report from 2 listboxes? I have attached a pic of what I am trying to accomplish. I am wanting to have a report open with only the criteria that a user selects from the listboxes. listbox 1: User selects a case number(s) listbox 2: User selects the...

Because I am an idiot! It just dawned on me to place my control after the fHandleFile... "fHandleFile(Me.txtFilePath,WIN_NORMAL)", and it works like a charm. Thanks for making me look at the code again!

Yes, I had this part. For some reason I was thinking that I had to call the Private Declare Function apiShellExecute. Obiviously I cannot read very well, because when you pointed out the "usage examples", then it was like "how did I miss that". Anyway, after seeing it work, it is not what I...

Ok, I am a dummy! I cannot figure out how to call the Private Declare Function apiShellExecute of the API code from the link above. I have tried: Call modapiOpenFile.apiShellExecute modapiOpenFile.apiShellExecute apiShellExecute(Me.FilePath) apiShellExecute() I am trying to call the...

Paul, I did see this code a while back and then forgot about it. I'll give it a try, thanks!

Poppa Smurf, Thank you for your response! The reason I was trying to use the "GoHyperlink" code was due some inherit issues with "FollowHyperlink". Here is a snippet from Allen Browne's site: Again, thank you for your response and I will keep your code incase I dont get things worked out.

Hi Paul, The code works in opening the links stored in my table. The problem is that when the file to be opened is either a PDF or Word docx, then the files open in the background. So, I have to click on the open file to move it into the foreground. If the file is a .txt file, then it will...

Has anyone used Allen Browne's GoHyperlink? If so, I was wondering if you had an issue with PDF's and Word docx's opening in the background of your Access database and were you able to correct this behavior?

You can place this code in the Onload event of your form and this will change all of your boxes at one time. Delcare the control: Dim tb as Control For Each tb In Me.Controls If TypeOf tb Is TextBox Then tb.BackColor = 'your color goes here End If...

Can you post your db?

Try removing the "Call" from in front of the unlockfields and see if that changes anything. Also, did you copy and paste the code into your form? if you did, then something is not setup correctly, because the unlockfields should be UnlockFields

I have a feeling that the problem may be in your DLookup: If Me.txtPassword.Value = DLookup("Password", "tbl login", "[Employee name]=" & Me.cboemployee.Value) You are asking Access to compare a string , from the [Employee name] field, with a number , " & Me.cboemployee.Value. I think it...

Mark, Access will create an inner join for you to accomplish what you want by add fields to your form using the "Add Existing Fields" button from the Access toolbar ribbon in design view. As far as coding for the "Save" button, just use the standard macro and then convert the macro to vba...

Are your combo boxes all on the same form? If so, then you can reference them by using Me. instead of Forms!Product!cboShape: So Me.cboShape Also, you can use the Case Select statement for your combo box if the value are constant; Private Sub cboSpecies_AfterUpdate() Select Case...

Can you post the function or sub you created. Also, are you calling the code from the form or from a module? Oh, on the color change for the subform, I have not been able to get that to work yet

I have a Function that I call whenever I need to lock down all of the controls and I use it in the load event of my form. With this code, you can still navigate through your subform, but the user cannot enter any data until the the controls are unlocked. Private Function Lockdown() 'locks...

CJ, Thanks for the reply. That is what I thought, but I was not 100% sure.

Hello, I have read where you can drag fields onto the tab pages to create a form or you can place a subform onto a tab page, but can you drag an existing form onto a tab page? I have done it and it is working, but I just wanted to know if this is ok to do or would it lead to problems down...

aah! Thanks mdlueck!

I got his module to work, but I cant find him to show him what I had done. The guys post disappeared. Also, I noticed that another guys private message to me disappeared; was there a reset to the forum or something?