Search results

I have some forms that have multiple cascading combo boxes. When a user selects an item in the listbox then I fill the form. The problem is Problem is... the screen flickers while loading, because there are so many combo boxes. I have tried hiding the fields while loading and setting the...

Many years ago when I used to teach relational database design, I really didn't care for it either. but under certain circumstances it works.

Well I figured it out and it was toooo simple. I had anchored the header Amount to the right so every time I would run it the labels moved over. Thanks everyone for responding. I do truly appreciate it.

Unfortunately it would be very difficult to create a sample db. I did post my sql and added more pictures

There is only one Amt field in the query and the field name is Amt. txtAmt is the name of the form field but it is bound to the Amt field in the query. I always rename form fields so there isn't a conflict in names. My pics may not be clear. I've marked the fields and will add them to my post...

I have several search forms. Each one is the same style, with similar queries. In fact, I copy one to make another. For some reason, ???, only one column In one of my search forms not displaying data and looks like the field is not visible. All of the other columns displays the data correctly...

I found out what I did. I carefully examined each line of code and I was setting my primary id to 0. Not sure why it accepted it but it did. Thank you all for your help. BTW I did create a new db to test but as I was doing it I thought I should look at my code again.

This is weird. I tried to add a manual entry and it worked. Maybe I'm missing something in my code.

Autonumbering is not working at all. Just tried to add another record and I got the duplicate values error.

I will try that. It's strange that I don't have any problems with similar procedures. I have a picture in my description that shows the PO procedure. No problems.

It's not the database because I tried running another procedure from a different form but setup the same way and it returned the id value.

I thought the same thing so I created a new table from scratch. I even renamed it just in case.

Am I missing something? For some reason I have a dao recordset that sets my autonumber field to zero (0). At first I thought that it wasn't returning the new autonumber id but when I opened the table there was the record but the autonumber field was 0. I have tried numerous ways to get it to...

Hi everyone. About me...Many years ago I used to teach database design, stored procedures etc. at our local community college. I was a vb-4 to vb6 programmer and then later went to .net. It's been years... and years since I have programmed but I needed to make an estimating program for selling...