Search results

I just figured it out I think. When setting up the Switchboard I set used the option of "Open Form in Add Mode" instead of "Open Form in Edit Mode" Man, I guess if you learn something every day you're on the right track. Thanks for the help MStef

Okay, here's what I'm seeing. I did this and it works when I open my main form. But, when I use my Switchboard to open the main form I can't browse through the records. I did the same thing, you mentioned, with the Switchboard and it didn't fix it. Safe to say it's the Switchboard causing...

Hey Gang, Thanks for all your help on my previous problem but I now have another one that just seemed to start out of the blue. When I open my form the record selectors don't allow me to browse through all the previously entered records. This is a huge problem because if changes need to be...

I can't seem to get this working in my BeforeUpdate section but I'll keep working on it.

looks pretty complicated at first glance. Is this sort of how each one is broken down? If Me.txtUnitCase = 0 Then MyMessage = "The Units per case must be set!" & vbCrLf & vbCrLf & MyMessage Set ctlWithFocus = Me.txtUnitCase End If "Me.txtUnitCase" is the field name? do I...

That did it RuralGuy!!! You're great! Can I go a little further and ask if there's a simple way to have it so that if there is a required field missed, the pop-up tells the user what field it is?

nothing there at all. It's pretty basic seeing as I'm a basic user. Should there be something there?

Sorry, I should have been clearer. It is when I push the AddNew button that I get this message. In order to be certain I have entered all required fields I have market them on the form so that I know what is needed for testing purposes. I do get the "Object Required" pop up but it is no...

Thanks so much for the help RuralGuy! This did the trick but I do still get the message for a missing object even though all required fields have been entered. Is this normal for the code or am I missing something? Thanks again for the help, I'll be calling on you all again later today. hehe...

First off let me say there is some terrific info here on this site, great job! Also, let me state that I'm designing my first database so I'll likely be asking some really stupid questions. I'm designing a database which will allow customer work orders to be entered. The main form is pretty...

With this code do you need a line for every field in your form? I have about 100 fields in my form and if this is how it's done than that's okay but if there is a faster way I would love to know.

I'm having the same problem, can anybody help me please? I just want to be able to print a report from the form once I have entered in all the data required. I built the report from the form so I need to figure out how to pass all the info from the form to the report. Thanks for you help.

It was that easy?!!! Man, I really have a lot to learn!

Thanks SJ McAbney, cool avatar by the way. I was hoping for a simpler solution because my form is pretty big, I'll do up a report. Cheers

If you have a Print button on your form where you add records, can you set a specific font and background colour when you print or does it have to be the same as what's on your form? I have a red background on my form but I want to print just the text and in black and white.

Hi All, Another totally newbie question here but I'm still trying to figure a few things out. Leave it to me to dive head-first into something without first doing research. In my database I have a main form where I enter records for customers. Now, I also have a second form that is used to...

After racking my brains out about this it was as plain as the nose on my face. I was able to get this figured out by changing from a "Save Record" button to a "Add New Record" button. However, I could still use some help on how to set up pop up messages that say a certain field must be...

Hey All, I must first apologize for my total stupidity when it comes to MS Access but this is something that should be soooo easy but I can't seem to figure it out for the life of me. I'm working on a database and the two biggest issues I have at the moment are clearing all fields when I...