Search results for query: *

Good call there Lilliabeth! I even was able to do away with the query I was trying to use to sort before reporting, this way! I don't know why I didn't use this method before. Thanks alot.[medal] dmkolb@comcast.net

I see what's happening in report but don't know how to fix it. The table is in the correct order, sorted, but the report has the changes I made at the bottom of the report, not in the sorted order like the table! Any help?

MajP, First thanks for replying. The underlying table is being updated, OK. I can open the table and I see the changes I make, but if I open the report, it isn't showing the changes? Do I use the "on dirty" when I open the report? dmkolb@comcast.net

This is probably easy, but I'm missing it! I have a database that lists a Job number and some data for that Job. I have a report that shows all the information from the table. OK The problem I have is if I preview the report, then go back and add or change any data in the table, with a form...

I too am having this problem all of a sudden. I tried undoing the Tweak that stops programs from taking focus and still nothing, Arghh. Has anyone found the answer yet? kolbd@comar.com

Thanks Paul but I got that part working now. Now I have to sort the database on Days Late. How can I create a table based on a query, so I can then sort it by days late?

I've tried doing the calculations in the query but for some reason the query won't save and it won't close? On which line in the query should I do the calculations?

I need to compare a date in an access table to the current date and then put the difference, in days, into the table for use in querying the table later to find 30,60,90 days late, etc. I can compare the dates in a form, but I can't seem to get that info into the table. Any ideas how to get the...

I've been learning VC++ also. I have understood the MFC applications but win32 consoles are kicking my butt! Can you share some of the console projects you've worked on? If so e-mail me at dmkolb@comcast.net. Thanks

Zemp, thanks for all your help! I finally found the problem! It was in the database itself. I had called my table, (table) and I guess it confused everything. Once I changed the name of the table, everything connected. Thanks again. dmkolb@comcast.net

Zemp you have been great in baring with me in this. I saw a note posted by VB5prgmr? that said to walk thru the data form wizard, which I did. BUT I still get the same Error in FROM statement with that! I know I've followed everything you and others have said including MSDN but I seem to have...

Thanks for baring with me. Yes the settings you show are what I have. I started over with the VB Application Wizard and this is the basic of what I have now. Now I get an error in the Move_Complete section. Can you see what I'm missing? I also have no highlighted buttons on the control to use...

Thanks for geting back to me Zemp. I am new to ADO. I set up an ADO control vs. DAO control and contacted the text boxes to it, but I'm getting am error now that I don't understand. 'Expected query name after EXECUTE' Can you tell me what I did wrong here? Thanks dmkolb@comcast.net

Hello, I am using a form in VB to access a db to view, add, edit, etc. The addnew button adds a record to the bottom of the table but it also over writes the record the datacontrol happens to be on at the time the addnew is used. Below is some of the code, I hope someone can help me with this...

Hello, I am using a form in VB to access a db to view, add, edit, etc. The addnew button adds a record to the bottom of the table but it also over writes the record the datacontrol happens to be on at the time the addnew is used. Below is some of the code, I hope someone can help me with this...