Search results

I'm trying to do something similar. 1. I have a textbox called txt_awb 2. My table is named tblStorage 3. The field name is awb 4. I have a textbox called txt_warning When I type in a number in txt_awb (f.e. 001-2004 3543) I want access to check if this number already exists in my database. If...

I got it all working, although now I try to figure out how to look if the value in the textbox already exists after inserting a number in the txt_awb textbox. If I understand it right I need the Dlook method for this?

Many thanks !! :D

I think I need a bit more help, I'm pretty new to VB but learning.. What I have so far is: (tablename = tblStorage, fieldname = awb, textboxname = txt_awb) It tells me I have no variables set? I'm pretty much clueless on how to do this..

Thanks alot, I will try this :D

I have an unbound form with 3 combo's to look up a record from a table and the record is displayed in a couple of textboxes. I'd like to save the values of the textboxes to a record in another table by clicking a save button. I don't have relational tables.. Does anybody know how to do this? I...

Thanks alot ! I'm a beginner and this will make it alot easier for me :)

I tried to search this forum but so far no results. If this question was already asked I apologise. In my VB I use the following script. I was wondering if there's a way to make this script shorter

Importing everything into a new database actually worked.. Thanks! :D

I only have modMouseHook1 in my modules. When I try to rename it to modMouseHook I get the message that module already exists. I'll try to start with a new DB and import the tables and forms. Thanks..

I have a slight problem with my acces DB and I don't know how to solve it. I tried to install the mousehook module and something went wrong the first time, it corrupted my DB file. Fixed the issue but uninstalled the mousehook module. Today I tried to install it again but I get a compile error...

Never mind, figured it out, it's in the VB editor.. Thanks for this post

I don't have an option to set a reference to excel in access.. am i doing something wrong?

How do I make this part of a case? I tried searching the forum on cases but it's hard to find something usefull.. I could really use a small explenation.. I'm trying to achieve something like this: Case 1 Me.cbo_method3.Visible = True Me.cbo_method3.SetFocus Case 2 cbo_pg2 = Null...

Many thanks, that was what I was looking for :D

I have a button and I have an invisible field. When I press the button I would like the button to make a combo visible and jump to that same combo On the click event I tried: cbo_method2.Visible = True DoCmd.GoToControl "cbo_method2" But since the combo is not visible when the button...

That's pretty good but mine works a bit different, I have a negative checklist and when an item is not correct they can tick the reason. When one of the boxes is ticked I want my accept checkbox to disappear and the reject checkbox checked. When I uncheck the reject button I want my 30...

Because I'm printing the form directly and haven't bothered to create a report yet.. Will probably do so in my 2nd version but I have a tight deadline

I have an unbound form and unbound controls, meaning I don't have the problem of scrolling through my records when I use the mousewheel. I would just like to scroll my form up and down with the mousewheel. Setting the cycle option to form or record only doesn't work for me... If anyone knows a...

Works now, thanks alot boblarson. Appreciate the help..