Search results

Thanks, i will give it a try and get back if more needed

I want to know suppose if the users working on same table will effect the insertion or saving of the data, say it if they press button for same report generation does it effects.

The purpose of doing so is bit unclear, could you please explain elaborately. Do you have table structre set up already? and so which table you want to send the details?

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?

There is no duplication in Exporting: As i see table i see as M0001, .... so on... Where as it export as 1, 2...so on. Thinking if i can make my own primary key for of this kind then it can be avoided too..any light on it>?

yes, thanks i have solved the mystry, the above code was making a temp query from strqdf all i nedded to dao was to export the query, not the table

Yes the first option was right for primary key

Thanks that was silly: still stucked on docmd line as says: Error 2498 : An expression you entered is the wrong data type for one of these arguments.

Internal No Name Product (it is unique for all transactions and goes to client too) ----------------------------------------------------------------- M00001 Nhasd afdasasdad M00002...

here i am searching for the records whose daterecived is after 10 working days and exporting the result in Excel. Me too had made this roughly and stucked in between.

And in other hand if i want to define my own primary key in it without using system ones, then what need to be done.

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

Could u able to provide the sample of your mdb, remove confirdential matters before posting

The OrderBy property "sticks" only when the form was opened in design view - then form view & a filter/sort applied - then saved. To fix: open form in design view & clear out the Filter & OrderBy properties. Save the form. This should remove any filter/sort when the form is reopened in form view.