Recent content by Drunkenneo

Try msgbox"Your new record number is:" & rec!ID

Hi, this question i googled but unsatisfied results, please help me out: I have excel, which i want to import in Access, but i need data type to get changed as text when imported, how can i do that?

I have MDB as FE and BE, Could it be possible to auto compact the BE by any means or chance?

Nice One, But there is a constraint I am using split form here and view as datasheet view, due to which filtering is needed.

55, fields

I am working on universal search as the code : Dim sFind As String Dim sField As String Dim sFilter As String If bFindLastKeySpace Then Search.Value = Search.Value & " " Search.SelStart = Len(sFind) + 2 Else Search.SelStart = Len(sFind) + 1 End...

Hi, I want to know if i can use the current currency Value, 1USD to xGBP in my access extracting ot from web, if yes then how?

The attached file is not opening, could you please send it again.

Does your these two tables are related one to one relation ship, if it is so, access will take care of deleting all the rows related to it. If not could i know exactly which datas you want to delete and taken care of by VBA?

Hello, I am in current situation where i need to make a qc form. Table serial No trackno name address 12 123 Neo nnn 13 124 Neo nnn 14 125 Neo nnn 15 126 Neo nnn 16 127 Neo...

I tried the same situation and in the submit button i have close the form, when pressing the submit, i gives error message and does not save the record, but closes the form. I want user cannot close until information is fully provided.

I have to design a table i know its piece of cake. Here i want user to continous form which wil be once in a month needed is EUR USD From To User will enter the line with values and the period with valid dates. Since its a continous form i need user to fill all the details...

I have a form which have subform as a datasheet view. Here i want to put a counter on top of form when i filter the record set it should be showing that count too. Is it possible?

I have a table Main Name Inter Intra Flag ------------------ A BB CC as DD FF And Table Code table: code Flag ---------- BB 1 CC 0 DD 0 FF 0 All the Flag reference taken from table, I want an update query where it checks if either of...

Bump!!!Bump!!!