Search results

Hey everyone. Right now I am trying to find a way to filter to a specific page on a form upon opening I have two forms, one for entering information and one for editing the information. When your on the "Search Info" page and you double click a record, that record is opened in the "Edit Info"...

Hey guys, Right now I have a command button on my main form that opens a browse box and lets the user browse for a document. Everything works fine, except if the user opens the browse box and hits cancel an error will pop up telling them that the path/file is invalid. As soon as they hit end...

It's usually pretty strict here when it comes to uploading data (even the bogus kind) unfortunitly. I'll play around with it though and keep you posted if I figure out what i'm going wrong.

Hmm, I tried that code out but didn't seem to have any luck. I have the Tag property on all of the controls on the page as Lock but it doesn't seem to make any changes when i check and uncheck the lock button

Hmm well im not really too familiar with arrays. I think the other method should work though if I can get the kinks worked out. I modified it a little to: Private Sub OptionLock_GotFocus() Private Sub OptionLock_GotFocus() Dim ctl As Control If Me.OptionLock.OptionValue = 2 Then For Each ctl...

Haha alright that makes a little bit more sense then. I tried doing the tag method as it seemed a little more straight forward. Right now i have the code: Private Sub OptionLock_GotFocus() Dim ctl As Control If OptionLock = 2 Then For Each ctl In Me.Controls If ctl.Tag = "Lock" Then...

1. Use a main form/subform where the main form is just an unbound form so you can have your option box and then the subform is an unlinked subform for having the normal main form in it. Then the code would be: (you would set the normal AllowEdits of the subform to NO) Code...

Hey everyone, I had a question regarding option boxes. I have a form in my program used to edit information. I would like this form to be locked upon opening to ensure that the user doesnt change a value on one of the records by accident. At the top of the form I would like to have two option...

Hey everyone, got yet another question for you. I'm trying to set up a logistics system which assigns each product a locating number. There are three types of parts, one ranging from 0-10,000, one from 10,001-20,000, and lastly one ranging from 20,001-30,000. I plan on having my system set...

Hmm when i try to import it into a new database I get the same result. It says importing, but then nothing happens. All of the other forms however import fine.

I have a weird one for you guys, I have a data entry form with probably around 400 controls. From my understanding Access has a 700+ capacity. More likely then not this is due to a large number of controls I have deleted that still have slots reserved for them in the background. Needless to say...

I would not make it the autonumber field. Additionally, it would not work correctly since you might have gaps in your sequence when you first start adding products. So would I just make three tabes and make one contain just the number 10000, one 20001, and one 30001? By the way, how will you...

Hey guys, I am trying to set up a logistics system to store products. Currently there are three different product types. I would like one type to be numbered 0-10,000, the second 10,001 to 20,000, and the third 20,001 to 30,000. You guys pointed me in the right direction and told me I had...

Good idea. [part number text box].value=dmax("Part number", "Parts")+1 So the ("part Number","Parts")+1 represents (Query Name, Column Field Name)? how do i set up a dmax function exactly?

I was a little bit confused by the dmax functionality. [part number text box].value=dmax("Part number", "Parts")+1 So "part number text box" is just the text box that feeds information into the table. What do the "Part Number", and "Parts" variables represent? Also, would I be able to...

Thank you for the replies guys. I am not too familiar with the dmax command. I was thinking that I could just add a hidden list box to the product input page to store the part number. I'm a little stuck on the code though. I'm guessing it would be something like the following: If Product...

Hey guys, I was wondering if you could help me out with a problem regarding a part locating system. We have three different types of parts and would like to group them by type. We would also like to give each part a number that could be used to locate them. Ideally we would like our...

Good deal, works perfect now. I tried to add to your rep as a thank you, but I already did so on a previous post so it wont let me do it again. Thanks again tho

I did find a couple of kinks though, one of them being that if i select a field value with more then 1 word it comes up with the error Syntax error (missing operator) in query expression 'Total Displacement'

Awesome, it works! Thanks a lot for all of our help I really appreciate it. I've been trying to figure out how to do that for the past month. Well done.