Search results

It is easy if you just want to import the table in be of Split Databse in server, just right click and import the table. But if you want the table to split in BE and FE again, i would suggest don't do at run time, that will be lethal. It is very easy to 'unsplit' the database. Open the back end...

There is access you need to take care while in date format, it queries with mm/dd/yyyy i.e american format, If you setup your query with mm/dd/yyyy then it will execute the result.

Currently i am using code f is tbldataentry.origin g is tbldataentry.dest p = DLookup("flag", "tblCodes", "Cod_ID = " & f) q = DLookup("flag", "tblCodes", "Cod_ID = " & g) If (f = g) Then MsgBox ("Origin and Destination cannot be same, Please Check") Exit Sub End If If (p = -1 Or q = -1) Then...

Here i have added an image which will be ok for explanation

I am strucked to a simple join query please help Here I want to update the Flag of tblDataentry if any one of the orig or dest is -1 else 0. Please Help

this is lot to ask, but i have to as i searched all the forums for idea. I have a dateTravel field in table Datatype "dd/mm/yyyy", which is populate from the form textbox, having long date format. I have to check duplicates before writing to table which i made a statement: int1 = DCount("*"...

Private Sub ord_id_AfterUpdate() 'DISPLAY RECORDS FROM MASTER ON BASIS OF COMBOBOX VALUES On Error GoTo Exit_cmd_Details_exp_Click Forms!Master_Table!fsub_master.Form.RecordSource = "select * from Master_table where norder_number =" & ord_id.Value & "" 'DISPLAYING RECORDCOUNT AT BOTTOM OF...

I have searched all over but not got any idea, Situation is i have a subform which is controlled by a query eg . Fname&" "& Lname as Name, order_number. and i have form which have combobox. When form opens the query works fine but when i search value order_number in combo box it gives the...

U can use between 12 and 36 instead

Indeed, DoCmd.RunCommand acCmdSaveRecord CurrentDb.Execute "DELETE FROM tblDataentry WHERE (tktNo Is Null Or flightNo Is Null Or dateofTravel Is Null Or dest Is Null Or origin Is Null) And staffName=" & Forms!frm_Main!Cmb_Staff DoCmd.Close as DoCmd.Save does not save record, it saves the...

I Found where i went wrong in the code, its solved now thanks guys..

I Tried but both times running on same query, DELETE Nz(tblDataentry.tktNo,""), Nz(tblDataentry.flightNo,""), Nz(tblDataentry.dateofTravel,""), Nz(tblDataentry.dest,""), Nz(tblDataentry.origin,"") FROM tblDataentry WHERE (((tblDataentry.tktNo) Is Null) OR ((tblDataentry.flightNo) Is Null) OR...

I have written a code in VBA DoCmd.Save DoCmd.SetWarnings False DoCmd.RunSQL "DELETE Nz(table.tktNo," & Chr(34) & "" & Chr(34) & "), Nz(table.flightNo," & Chr(34) & "" & Chr(34) & "), Nz(table.dateofTravel," & Chr(34) & "" & Chr(34) & "), Nz(table.dest," & Chr(34) & "" & Chr(34) & ")...

I have a Form and a subform: Subform: its an direct display of table with the datasheet view ID Name order_number process_date Status And i have form linked on parent/Child on Order_number. Problem is when i open form the subfor displays only single order_number record, eg 3 records for...

I want to add an event on Form Header when double click it will filter the values, which i did with macro, but could it happen on second time double clicking it it refreshes whole as original?

Any other way where i dont have to use combo box

I have a text box in Form which i need use should only enter the numbers: for eg: When new form appears SI [space]#### should be there and even user needs he or she can change SI to PI and enter the required data. And the data should go as SI #### or PI #### in Table Backend. The Textbox is...

It is clicking on any buttons on forms is not functioning, means no save, no refresh and nothing... There may be chance of network drop, but if network is not dropped then what are the chance and how can we rectify it..

I have a multiuser data entry form which on using somtimes gets inactive, means the button stop working and we have to close the form and open again to avoid. Does anyone have any idea whet to be taken care?

I am quite sure this can be do without it also. however trying at my end..