Search results for query: *

I have. Unfortunately I am at the point of having to hire a programmer to fix the errors in the database. I have been digging deeper and I have some troubles in the VB code. As it stands, it is beyond my experience to analyze and fix Mike

Thanks for taking time with me over this issue. I am going to actually start from scratch tonight and redo the database. Because I was converting an existing database I am not sure where the error was introduced. Will let you know if I am unsuccessful and have to go back to this one Mike

Thanks both of you. But the problem isnt that I am seeing data from different incidents. The program is corrupting the table and reassigning the data to different incidents, quite maddeningly I might add. The master/child link is established. I have done it manually to make sure. If you...

I have a main form and on it INCIDENT is my unique number. From Main Form I call up form1. On form1 I have a subform that is in continuous form view. What I want to have happen is that information entered onthe subform is linked with the specific "INICENT" What ends up happening is that when...

Thanks for the valiant effort. I have decided to continue on the database development and come back later to the "back.color box" question. I have to get this out for my clients use and I am going to have to live with it not doing that right away. Silly MS not allowing us to change...

The line in Form1 looks like this Docmd.OpenForm etc. If FORMS...... When the call returns from FORM2 it does not even execute the IF THEN statements (did a debug check and it didnt run them)....so I am not sure where to place the code now. I really appreciate the help Mike

I am sorry, but I am not familiar with the term "modally". The on-click event is a docmd.close Is the code correct as well? Mike

Access 2000 and VBA I have a series of forms in my Database. I have my main form (FORM1) and on the bottom of it I have rectangles with text in them and an "on click" event that takes me to (FORM2) or (FORM3) etc. I come back from each form to my main form. Once input is complete...

Ended up having to delete and start again. Once I did that everything worked fine. Not sure why. Oh well. It is Access, and it is very good at somethings and very confusing at others

Hi ya. Happy New Year. I created a switchboard using the switchboard manager in Access 2000. It created the underlying tables and it let me set up the various buttons, but it never created the form. Every time I go back into switchboard it shows that it is still there and the names and...

Ended up having to go back to a back up from last week of the database that I am working on. It was corrupted. The <SHIFT> did nothing. It was really wierd! I am going to change the variable DATE that I am using on my form, because it is getting too confusing as to where I am looking at...

Excellent. Will do. Now (hopefully) only one more question. On both the main database and the backup I have now lost ALL of the startup forms. By that I mean....when you start a new database you have a box on screen that allows you to create using....forms reports tables querys. It...

Let me Clarify what I found. When I find an older WORK ORDER and get a correct match, the routine changes the present setting in the field DATE, as well as writes the older date into LAST_DATE. The data in DATE I dont want to change. It may be today or it could be archival data....all I want...

Excellent help...thank you so much. Only catch with the code is in this case: DATE = Today (31 Dec 03) The sort finds a previous record for Dec 9th for the same unit. It correctly makes LAST_DATE = 9 Dec 03 and then resets DATE (which should still read 31 Dec 03) to 9 Dec 03. In the other...

Two more issues.... Why if isblank(me.SERIAL_Number) then me.TYPE.setfocus me.SERIAL_NUMBER.setfocus exit sub else if isblank(me.TYPE)then me.TYPE.setfocus exit sub else TYPE in both instances of isNull()..is that a type and now it is not accepting this line set rec =...

Boy I really appreciate your help. I have been working on the code all afternoon. Problem dim db as Database comes up as an error.....not defined? also I discovered that in the main database I stored the value MAKEID (key number) that refers to the TYPE. SO I am trying to sort that out...

Not so far. I have to make some adjustments in names as I was working off of the names in the query...and they are different than in the table Let me know thanks both of you. I really appreciate it Mike

Thanks again both of you. KPHU you are correct in each and every assertion. I am sorry if my name conventions are very clear. It has been a while since I did any coding and I realizing that my use of labels and forms and tables with the same or similar name is very confusing. Anyway, you did...

Hi kphu. LAST_DATE is &quot;&quot; at the start of this exercise on the open form WORK ORDERS {TextBox}. All info is stored in a database called WORK ORDERS. I am searching my query of that database called qrySEARCH because the query places the items in question ordered alphabetically...

I understand your suggestion. What I have been trying looks like the example in MSN database #199056. I want to return the Find.First on my Query. The query is in descending date order. That satisfies my need to find the most recent record. What I dont understand is the function of...