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...

I like it when you're bored :D Works great, and without any conversion bullshit. Thanks, Koen

Ok, I can have part of it working already using this code in the afterupdate event of one of the time fields that are part of the calculation : If Me.Delay > "0,00347222222222221" Then [Delay code].Enabled = True If Me.Delay <= "0,00347222222222221" Then [Delay code].Enabled = False End If...

OK !!!! I was calling for help too early again !!! I fixed it by setting the calculated field properties, format to standard date and then the formula [end time]-1-[begin time]. Works perfect !! Didn't see yet you already replied on my 'panic reaction', thanks a million for the help you've...

Rob, I can't get it to work, it's giving me a syntax error when exiting the name field in the query design. It says missing operator or wrong character, etc. in both suggestions that were made in the thread I referred to. Any ideas what is wrong ?

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 was already afraid it was an office problem. Strange thing though is that on both our laptops this only happens with this specific DB, all the other DB's behave as should be... I'll try the reinstall, thanks. Koen

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...

Works great, thanks !!

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...

Thank you very much !!!!!! Working perfect now...

Is this what you were trying to achieve?? http://users.pandora.be/koen.coenjaerts1/db.zip

Well, that's what I'm trying. Let's say for example I'm on record #17 on my main form and want to sign off. So I click the button and the pop-up opens. The values I enter in here should also be stored in record #17, but for this the pop-up should open first on the current record# and that's...

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...

It's working partially now, so I think I'll be able to get it sorted completely now. If not, I'll let you know... Thanks, Koen

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

Ok, thanks for the help, I have it working now.

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...