Search results

Your welcome, glad I could help.

That is what I do. You can also add a cmdButton for new customers right on the form if you like. I just started using the searches and they work great for finding part no and customer no and names and the like. It is just another form, but you can find and set a lotof this with it also. hth.

It sounds like you need to understand dbase normalization, first. Try reading the three short articles at this site and then it will make easier for you to understand and it will probably answer most of your questions. http://www.microsoft-accesssolutions.co.uk/table-of-contents.htm hth.

I have been there and won the tee-shirt and wore the hat. When it happened to me was when I either delete a control or changed its' name, I don't remember which. To make a long story short, I accidently discovered it in a reports GroupBy, under the old name. So there using find to first...

Dumbe question here, why not just make the RecID of Form3 a combo box and they can just pull down and select any time they want. That is the simplist way I can think of, but of course there a couple of search pop-ups that you could add to make it more fancy. hth.

It very simple means that the data types, between the table and the form are different. For example one is numeric and the other is text. Also check field sizes in the tables vs. control sizes in the form. I have not tryied to run DLookup or DCount against more than one table at a time, but...

Glad it is working, good luck with the rest of your project.

Can you at least post the OnClick code? It would be help to see what does not work.

First of all a form is just a window for a table or tables. It can create records, modify records or delete records. I am not sure what your form looks like or what your OnClick code looks like, can you post your code? What might be more helpful , can you attach a stripped down version of the...

Your welcome, glad I could help.

The first record is where the default is, unless you tell it which record to go to. Here is an example of a OnClick event for a cmdButton which opens a second form to the current record on the first frm: Dim stDocName As String Dim stLinkCriteria As String stDocName =...

I uderstand what you are trying to do, I think. That is why I suggested using: =Environ("UserName") Put this in the default value of the ID field of table. Now you will autonmatically get the user's logon put into the field with every new record you create. Oh you can reset the tab stop for...

I think the easieat way would be to just create simple form and have that open on some event like the form's OnOpen event. After the ID is entered you probably could even use DLookUp to get the rest of your data. Then close the form. But if you are only trying to get a username for who...

Yes, that is one way, but I like to make them invisable till a certain control is filled in. In the form's OnCurrent event, add something like: If Len(Nz(Me.MyDateControlName, "")) = 0 Then Me.MyComboBoxConrolName.Visible = False Else Me.MyComboBoxConrolName.Visible = True End If You...

Maybe something like in the OnClick event of a cmdButton Have: DoCmd.RunMacro "MacroName" Sense the macro works fine, use the cmdButton to run the macro. Just my two cents. hth.

You might want to check this out: http://support.microsoft.com/default.aspx?scid=kb;en-us;159220 hth.

Did something like that once myself. Except being suborn I desied to make it work, well three days and a lot of posts and many visits to reference websites and the knowledgebase, I got it working. I learned a lesson, get it right the first time or live with it. I t gets into all kinds of...

I use DLookUp myself, but sparingly, because it can be slow. So, let me shoot from the hip with a couple of suggestions. In the table, change the txtbox to a combo, in the lookUp tab, for the ProductID. set the Row Source for the Products table. Next in the form change the txtbox to a combo...

I just finished a wrestling match with Cancel myself, what a nightmare. One dumb question first, I am confused at why this line is here: If ctl.Tag = "Required" Then The next line should handle everything, I would think. What I found in the out, because yours looks a little like mine, is that...

Well here is my two cents worth, I usually put my .Requery in the control's GotFocus event. I think that it is the Form's OnCurrent .Requery that is causing the error. Try commenting it out. hth.