Search results

Problem solved. Just had to restart the PC.

Hi, A working database and front end. When trying to add a macro to open a form a drop down list does not show. Normally just typing in 'Open' shows up all the macro related to 'open' in the drop down list. atached here is the error

Cool ! Thanks paul worked like a charm. :)

Hi, I am trying to deny users from logging on from multiple pc's. Here is how i've got it so far, created table tblLoginLock with fields EmpID and LoggedIn both numberical data type created a form to set the Empid with tempvar!TempEmpId and LoggedIn as 1 when a user logs in When he clicks the...

Thanks guys, It was the Write issue that i had to enable for the back-end database file for that particular user on the domain. problem solved.

6th pc, that was just a way to refer as another pc on the network which has this issue. It is setup like the others no difference in anything.

I was trying to run the front end on the 6th pc and this error "You cant go to the specific record. you maybe end of a recordset." showed up. But no such problem for the others. Any idea why this is happening ?

Oh ! Thanks alot galaxiom

Hi All, I was wondering how i can run a 64Bit access app on 32 bit OS when the run time supported is only 32Bit as the OS is 32bit. The app was built on a 64Bit MS office 2013. I tried installing the 32bit version of 2014 run time as the 64Bit did not work out. Thanks

seem to have solved it :)

just noticed that the CounterA04 is omiting the first line, so when there is only one A04 line the value becomes 0 else if there are 2 A04 lines it is 1. How can i change it to read the first line also

Well that did help for a while it missed out one file with MIRType V and this code solved it DCount("FileID", "qryVLD", "([MIRType]=""A"" OR [MIRType] = ""H"") and ([mirtype]=""" & MIRType & """...

Tried that but result is the same :( MIRType with R is also omited If DCount("FileID", "qryVLD", "([MIRType]=""A"" OR [MIRType] = ""H"") and ([TicketNumber]=""" & tkt & """)") Then 'validate MIR Sequence number and Ticketnumber to avoid Duplication txtMIRActivity.Value =...

ok ! thought i nailed it but when the MIRType is R it still say duplicate but it should not

I guess it was :) DCount("FileID", "qryVLD", "([MIRType]=""A"" Or ""H"") and ([TicketNumber]=""" & tkt & """)")

DCount("FileID", "qryVLD", "([MIRType]=""A Or H"") and ([TicketNumber]=""" & tkt & """)") trying to do a dup check where A and H are predefined and if other characters then it should omit this check, just wondering if the code is correct. I tried it out but once the data is already there with...

ah i then i guess thats the use of the 'and' part in it. So i guess best is to stick with the ElseIf, i guess. Now time to check on the A04 thing. will check and update , i guess the CounterA04 should be good work for me.

oh and the tutorial on the comas was helpful, Thanks :)

Tried the below code but it did not omit the duplicates. DCount("FileID", "qryMIR", "[MIRSeq]=" & MIRSeq & " and [MIRType]=""A"" and [TicketNumber]=""" & tkt & """") but it worked when using it with ElseIf

ok seems like that all the MIRType used if validating is omits some useful data too. How do i set the mirtype part to a predefined alphabet like 'A' something like DCount("FileID", "qryVLD", "[MIRType]="A"" and [TicketNumber]=""" & tkt & """")