Search results

Thanks Both answers helped. I was reminded that we are running Citrix servers so all resonses are coming back Admin with the various server names. It looks like creating a separate module with VB coding is the answer. Thanks again for the info. Time to hit the books once again.

Hi All. I've inherited an old db that frequently needs repairing. Does anyone know of coding that will check to see who is currently using a db so that we can have them logout and repair the db? Right now we have to go desk by desk. It would be lifesaver to go straight to the source. thanks

Add 'new' command to form load Putting this in the Form Load will open it ready to add a new record. DoCmd.GoToRecord , , acNewRec

Yes I tried importing the form - no success I tried importing the data to the db with the working form - no success I'm finding completely new levels of confusion

The query output looks fine. the chart in design view is fine. The datasheet looks fine. When I run the report it screws up the numbers on the primary axis bigtime. For example: 19.8 turns into 198.879.524.006 which maximizes all affected fields to their upper limits. Is there a way to set the...

let me say this better...lol the only difference between working and non-working versions aree that the non-working has updated data and 1 extra form which does not use or access any of the same info or any info with a relationship to the errored info.

all fields and coding are identical tables are identical except for updated and one form that has no similar or related fields to the form in question. thanks for trying..

This isn't major but it's bugging me. The default for a form field doesn't autofill any longer. It used to function fine before I imported a few tables and a form. I even took an old copy of the whole db where the default works fine, imported my tables, and after verifying all references and...

more details I have a fully finctioning db that works great for the quotes. My boss wants the repairs integrated into the same table. RepairID and QuoteID keys are both going to be called QuoteID and reside in the same field in the same table, so all forms, queries, reports, macros do NOT need...

Am I insane or is this possible? I have Quotes and Repairs each using a different (i.e. distinct) autonumber format which need to reside on the same table, in the same field. I tried using 2 tables which updated to a 3rd (Main) table but the formatted letter prefix (R for repairs) would not...