Search results

I do a similar thing with workorders. works fine for me. Private Sub Command247_Click() DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenReport "r_workorder old", acViewPreview End Sub Private Sub RadioUnit_AfterUpdate() If IsNull([Unit]) Or [Unit] = 0 Then '[Unit] =...

Processing a lot of invoices (500-700 per month from multipul vendors) has dogged me for a long time. partial deliverys, delivery slips (BOLs). The system that evolved is working well. actiondate is ()now description field contains the iv# and any desc note, posted y/n field posted date is...

I think echo is a screen print and print is a printer print.

welcome to the neighbor. What version of access do you spend your time and effort on?

Thanks for the interest. The front end already restricts operators from deleting records from the form level. A record was deleted from my back end data tables. I am not sure how or who. But it made me aware of the posibility and that is a consern because if can be done in one table, it could...

Having more than one database is like having more than one watch. You are never really sure what time it is.

I guess I need another lesson. Records cannot be deleted from my front end forms. I just discovered one record from my back end units table that is no longer there. I may have deleted it in error. Is it possible to password deletions in 2007?

It is interesting to read all the post on this subject. I am a relative newbie so my 2cw may only be worth half that much. but here goes anyway. It seem that the 1st question is when to switch from Access to SQL etc. This is a question I kept thinking about as I worked on my Fleet Management...

Big shots are really just little shots who kept shooting. That is one of the reasons I am updating my skills as a Fleet Manager by learning Access2007 and developing my own AccessFleet. I'll likely never be a big shot, but if my effort makes my work eaiser and becomes part of my legacy, OK...

Bob: Thanks for all the good recomendations. I'll try and adapt them in my future efforts. I'll be looking thing over today. I really appreciate your interest and your guidance and help. John..

after compact & repair win zip files are fe=982kb and be=9mb

it is a little big 8mb front end, 21mb back end Maybe too big to upload?

Thanks Bob: Report has right look now but the report no longer lists all the records with data in the Vehicle_type field. SELECT vehicle_type.type, CIPplanyear.PlanYear, EQ_sub_type.Eq_sub_type, Veh_sub_type.Veh_sub_type, vehicle_type.description AS vehicle_type_description, units.[RADIO_#]...

I have a report using the following tables but, the report shows the ID number rather than the type or description text. It is a little hard to follow and I would like to make the report more understandible. Muchas grassious in advance.. John. vehicle_typeIDtypedescription1Automobile...

Just a newbie asking a question.. Couldn't you just assign a default value of 0 in the general field properties?

Thanks Lightwave: I use a similar methodology for my weekly meeting schedule department head report and monthly safety meeting reports. Each time I change the db I go into access options\current database\application title and update the date. This help me keep tract of version. I'll try date...

Thanks Lightwave: It is a little tricky keeping track of where every thing is. When I messed things up the other day , I think I made the problem worse by trying to restore from a file with a different path. That is why I am thinking uniformity has some value for me. Maybe it won't be as...

Welcome TIA: I have a program with a parts table, a units table and a workorder table. the is a y/n field to mark a work order as closed. the on click proceedure below indicates how my inventory is updated and a bunch of other stuff. a lot happens when the box is checked. good luck with...

Well I got everthing working again. All the digging I did uncovered this result. I made new front end folders M:\office fe M:\notebook fe M:\garage fe M:\parts fe The back end folder is M:\backend data I was looking in Access Options at the default database folder on each computer...

UNITS table is nolonger linked, not sure why, but there is a unitsmaster table which is a mirror image of the units. Linking the two tables together should fix the problem I think!? Can I just link any matching fields or is there more magic required? I found what I found by looking at the...