Search results

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?

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?

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

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

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

I have access mdb which is in condition from last year, now its been demanded to make Multi user, if i just split to FE and BE will fiine or i need to work at table level for making it working by multi users. Its not a data entry mdb, its Content management mdb. Please suggest.

I have a table in database, with pk as internal no and in normalised form. Here user will import an excel with the information having internal no, my task is to match the internal no and update the required row with the data. How ever i can do it, by running set of queries, i want to know if...

I have a table having column as date, format as mm/dd/yyyy and i update the column as now() using VBA. However some places the date is in mm/dd/yyyy and in some mm/dd/yyyy nn:mm:ss are appearing which is making the filtering of the data ambuige. Please Help. Happy New Year!!!!

I have a form with split view and data it taken from different table using join query, is there any way i can add edit form data and original table data gets changed.

Is Common Table Expression in access 2007?

Hi My code is: Private Sub btPending_Click() Dim penddate As Date Dim a, str As String Dim qdfTemp As DAO.QueryDef Dim strQDF As String If (CStr(Format(Now(), "dddd")) <> "Tuesday" Or CStr(Format(Now(), "dddd")) <> "Thursday") Then If MsgBox("Today is not Tuesday/Thursday" & vbLf & "Do...

I have a primary Key in table with input mask as M00000, but when exported it comes without M only digits are coming any suggestions on this

I have a situation where i need to import a table in Access which is in Excel, After importing i need to know how can i break it up differently keeping relation of FK and PK intact: For Eg Excel Sheet: Name Biz ID Biz Name Address1 Address 2 Address 3 OrderNo Order Date Person Record ID(PK)...