Search results

I made three tables Veh_type, Veh_sub_type & eq_sub_type. I populated all three tables with the data I wanted to use to select from on the fe I then added a look up field for the veh_type table on the units table on the be. It didn' t work, I tried to delete the field, it wouldn't let me...

Re: How to pull only needed datathis is the method in SQL view that I have used succe SELECT WORKORDERS.RadioUnit, WORKORDERS.[Workorder number], WORKORDERS.[DPS Workorder], WORKORDERS.OpenWorkOrderDate, WORKORDERS.CloseWorkOrderDate, WORKORDERS.Instructions...

I make a table named Vehicle _type that was intended to be a lookup field in the units table. I made it incorrectly I selected number field as the type. After I made it correctly as Vehicle_type2( a text field) I was unable to delete Vehicle_type field in the units table. The message indicated...

Hi Sadie: What the doc man said is a more precise way of saying what I tried to share with you. It sounds like you are ready to go so good luck.. John.

Hi Sadie: I think Lightwave is on point. Your system will need to be flexible. Historically things change. If you design a rigid system, the changes will make you nurts.

Hi Sadie: I just spotted this on wikipedia made me think of your project. You keep thinning about it and yoll getter done. John. Keys are some of the most important objects in all relational databases as they tie everything together. A primary key is a column which is the identifier for...

Hi Lightwave: I guess you are right. My experience so far has been, the more I think about the processes and how to simplify the work the possibilities become clearer and clearer. This program has already morphed into something so more advanced that the program it is replacing. I'll just...

Hi Arsenius: Well the next time I am in Staples looking for pencils, I'll look for one of yours. Welcome to the neighborhood.

Thank you Lightwave: Your kind words ring so true. I'll take an "ataboy" when ever I can get them. You are right about value interest by managers I work with. I am currently working on the reports. When ever I finish a new report (the last one, vendor invoice processing within start and end...

What do the A or B criteria reflect? If the prompt is always A or B why do you need the prompt. Why not have a A query and a separate B query?

Hi Arsenius: Greetings from the southern tier of New York. I am John (AccessFleet) I am a newbie 6 months+ and my main focus is access2007 development for vehicle repair and maintenance. I was a .car long before .com. Most of my work revolves around fleet maintenance. Programming Access is...

I am a access2007 newbie about 6 month of concentrated study. Unless I have missed something, the study aids I have used recommend that key field be system generated. Even when their real work is done in the back ground. This is a little different than my old dos based relational database...

I have bought a couple of different ones but the one that has helped me the most is Access_2007__The_Missing_Manual by Matthew McDonald

Hi Sadie: So you want new system to start where the old system left off. When I transitioned from my old dos based system to new access based system I started a fresh work order number series to permit me to see at a glance old system numbers vs new system numbers. How many old part numbers...

Hi Sadie: If you delete everything and start fresh wouldn't your auto generate number also start over? What do your auto generate number reflect? Why must they retain sequential integrity? reference data may mean more to you over time, at least in my way of thinking. I use...

I don't generally like to delete records. The tack I take is to use an "inactive record" y/n box. You could then code from view. During the development stage I used some bogus data, I deleted it by going to DATA SHEET VIEW select the record(s) and hit the delete key.

Sadie: If you go injto your form properties (data) you may be able to make the restrictions you want at the form level. Now The query you are looking at is in design view SQL view. When you run the query the box appears "Enter Radio Unit" then then again. The gray box just jumps on the...

SELECT WORKORDERS.RadioUnit, WORKORDERS.[Workorder number], WORKORDERS.[DPS Workorder], WORKORDERS.OpenWorkOrderDate, WORKORDERS.CloseWorkOrderDate, WORKORDERS.Instructions, WORKORDERS.[Supervisor/CrewRemarks], WORKORDERS.[Work type], WORKORDERS.[CLOSED WORKORDER], WORKORDERS.Miles...

Yes we use only forms for data enter. People get funny when the screen changes. Something often experienced in the table view. Forms also permit changing the field color for criticle data, License plate# etc. This aids in on the fly updating missing criticle information. We work on police...

Hi Sadie: Part number(s) are something I know about. (Fleet Maintenance 30 years worth.) You may wish to consider that is is frequently possible to have different parts with the same part number. One way to uncomplicate this to allow same part number, but different vendors or manufacturers...