Search results

sir spikepl error: OPERATION IS NOT SUPPORTED FOR THIS TYPE OF OBJECT.

Sir Paul am getting the error here: sir spikepl i'll try as well ... thank you

still the same error sir Paul

am already set to publish my MDB but I want to have a FE and BE application so that even 2 - 3 users can access them .... I tried to split it manually, but no avail... got an error RUN-TIME ERROR '3219'; INVALID OPERATION and highlighted my recordset ... (attached image) do I need to connect...

@Galaxiom that was my old codes, I tried using Dmax on PK and it worked perfectly fine... thanks

I got it!!!! thanks for the idea Jiri....ur d man! I used Dmax on PK to determine the last fileCode field and then compared the PK on the succeeding arguments... damn right! thanks

Hello Jiri, thanks for the heads up ... how would I do that PK found with DMax? any tips?

I used Dlast function to determine last record of such Field as reference, but as the fields are apart from the record it does not return the last record why is that so? attached is a sample of the records dim rYear as String rYear = Nz(DLast("returnedYear", "documentLog", "fileCode LIKE'" &...

Sir good day, this is the last argument to complete my Archiving system and have it published... I really need your help badly ... thank you in advance sir. http://www.access-programmers.co.uk/forums/showthread.php?t=244817

yes, I noticed it ... but still without your help bro, I wont figure anything else maybe till a week ha ha ha .. thanks again ....

i did it! Me.txtFileCodeNo = CInt(Right(Me.txtFileCodeNo, 4)) + 1 Me.txtFileCodeNo = Format(Me.txtFileCodeNo, "0000") thank you @Jiri for the help and idea ....

i also tried using txtFileCodeNo as the value is in the textbox ... but error says that TYPE MISMATCH Me.txtFileCodeNo = Right(CStr(CInt(me.txtFileCodeNo) + 10001), 4)

still not incrementing =( as am reading your codes .. it must already have incremented highlighted fileCode is the field in the table right?

still not incrementing =( as am reading your codes .. it must already have incremented =(

bro i tried, but number is not incrementing =( this is the actual fields and object names (also as per attached photo): combo box = cmbFileCode text box = txtFileCodeNo table = mainTableArchive table field = fileCode (values combined from cmbFileCode & txtFileCodeNo) Private Sub...

thanks for the reply, yes it is unbound .... i will try this now ... i'll give you a feedback..

Gurus ...in desperate need of your help =) situation is this, i have 1 combo box for FileCode (Alpha) and 1 text box for FileCode (Number). When saving it in the table it becomes FileCodeAlpha & FilecodeNumber e.g.: CAM0001 I wanted to do something like this: after selecting from combo box the...

oh I think its misspelled, anyway ... I tried the following codes instead of following that DLOOKUP thing ... but if you can give some solution for it ... it'll be nice bro ***what I did Set db = CurrentDb Set rst = db.OpenRecordset("tblEmployees", dbOpenTable) rst.Index = "Primarykey"...

Gurus, I found this wonderful login codes and I think its very cool...but 1 thing! I can't define USER LEVEL ACCESS after DLOOKUP .... can you share your ideas? thank you... Private Sub cmdLogin_Click() 'Check to see if data is entered into the UserName combo box If...

thanks for the reply John, I already solved it ...