Search results

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

I have a query: SELECT purchaseOrder.poId, purchaseOrder.poYear, purchaseOrder.poDate, purchaseOrder.userId, purchaseOrder.currencyId, purchaseOrder.poSendDate, partnerDetails.name FROM purchaseOrder INNER JOIN (orderDetails INNER JOIN partnerDetails ON orderDetails.partnerDetailsId =...

This is to know i have an excel report generated by Access VBA, It need to appear in excel with above address and below signature. Since i am doing this new, exactly i want to know in situattion like this what do i need to take care, becoz there is pagebreak in report with subtotals and end...

Hi Have Written this Code which is Showing Object Required Error in the line which have Asterisk: Option Compare Database Option Explicit Private Sub btGeneration_Click() '********************REDEMPTION FILE IMPORT*********** On Error GoTo Err_btGeneration_Err: Dim rs, rsord, rspurchaseord...

Thump!!!Thump!!

i have to write a result of the query to the excel, which is a invoice template where i need to enter the data. Depend on the result the template can grow in size also, here if the size grows there needs to be informatin coming on first page for eg: address in first page should not repeat in...