Search results

At work we have a very expensive program, used in the whole company, based on btrieve files but unfortunateley doesn't meet our departmental needs. For the moment I create reports out of this software - save them as a text file and then import the text into msaccess, manual operations are...

I have a defect form with a button that opens a sign-off screen. On this signoff screen I have 3 possibilities based on the kind of defect. #1 is the mechanic signs, #2 is a quality inspector sign-off and #3 is a second quality inspector sign-off. Data from defect and signoff screen come...

On my form I have a calculated control that holds a time interval, calculation is done in the query which works ok. The field is disabled. I have a second control, delay code( also locked) that I want to make active if time interval is >5 minutes. I've set the field property to short time...

I have created a field in my query that calculates a time difference, although as expected it doesn't work when start time is before midnight and end time after midnight. I had a search through the forum and came up with following thread ...

Hi again, I'm up to the next problem... strange one this time : I'm the onl y user of my database, have no security settings active and have not touched record locking as far as I know. Only thing is me and a colleague often transfer updates of the DB via IR between our laptops (we are both...

I would like to create a summary screen with data from several separate queries that are not directly linked to each other. On my main form I have several subforms and sub-subforms, with each specific data types and handling and writing this data into seperate tables. With the queries I...

Ok, I got everything working from my previous questions, thanks a lot for that... But, one more thing, in my main table I have a few fields which I don't want to show on my main form, in fact on these field the user has to sign off for the data he entered. These values just need to be entered...

I still can't get everything working the way I want it. I'm trying for days already, my pc has been hanging out the window lready etc... So, I've attached the database and a txt-file with what I want to achieve. It would be great if some experienced people could take a look. Thanks in advance

Next problem I have with the database is : I have a main form with a unique number for each record containing 20 fields. I have a subform on the page, which contains defects for each of these records (many defects for 1 record). This all works ok, but now I want to go down 1 more level and be...

I have a small problem, probably the solution will again be simple, but I can't get it sorted. I have created a table with some 20 fields in it, of which 1 is called maintenance type, a combo box and a second field being the date a specific type type has been performed. This results in a...

I have a problem with calculating a total in my report. I've created a report with 10 separate fields (each calculated totals of a number of records which match certain criteria). Up to now all works fine. Next thing I want to do is to make the total of the values in these fields. This is...