Search results

I get a syntax error for this DLookUp("[LockNum]","tblImportLock","[Open]=1") LockNum is of DataType Number I used macro to code the form. It just checks a filed value for 1 or 0. It had been working but just today an error poped-up.

Hi All, does anyone know how to transfer existing Access db to mysql. Would this increase performance as in searching and loading of the data.

Hi, I have a report that opens when opens should open an update query where the query searches for a filed Name like PNR and updates its YES/NO field to No where that field is yes by default I tried this in the criteria of the update query [Reports]![rptInvoice]![pnr] set the PRN fields...

Hi, A little confused about the entities in the table. In my table tblDelivery i can several repeating entities from the table tblAgencies. One agency has several deliveries. So is it ok to see several agencies(entities) in the table tblDelivery or is it against normalization. Should i be...

hi, am a new to programming so bare with me please. :) I've been trying to create a search form and i see that the continuous form with text fields is the best way to go by. So in the After Update event i use the set filter for each text box [CustomerName]=[Forms]![frmSsssearch]![txtCustomer]...

Hi, My query table is from another query. so does that preven some fields from displaying when using the criteria as [CODE[Like "*" forms!frmsearch!txtSerialNumber "*"[/CODE] one field works but when the next field criteria is added then the query result goes blank. So does the search...

Hi, I have a data entry form for which one of the field needs to be ignored when entering data but when doing so the error returns saying " You must enter a value <some table>" is there anyway to ignore this field when needed ?

Hi, i was tweaking one of my forms, now the results show empty when i search ? how is that possible the query is the same tho.

Hi, i've got a query that should also show empty records also. Tried using Or is null but that is not helping. The query has several tables also, is subquery an option here ? not sure how to do that either :( but is there another way to get the result. thanks

Hi All, I was trying lock a text box based on the value of two cmb box value if txtqty=txtstk then setproperty of txtserial = FALSE Else Setproperty of txtserial = TRUE here when run the code skips...

Hi, A working database and front end. When trying to add a macro to open a form a drop down list does not show. Normally just typing in 'Open' shows up all the macro related to 'open' in the drop down list. atached here is the error

Hi, I am trying to deny users from logging on from multiple pc's. Here is how i've got it so far, created table tblLoginLock with fields EmpID and LoggedIn both numberical data type created a form to set the Empid with tempvar!TempEmpId and LoggedIn as 1 when a user logs in When he clicks the...

I was trying to run the front end on the 6th pc and this error "You cant go to the specific record. you maybe end of a recordset." showed up. But no such problem for the others. Any idea why this is happening ?

Hi All, I was wondering how i can run a 64Bit access app on 32 bit OS when the run time supported is only 32Bit as the OS is 32bit. The app was built on a 64Bit MS office 2013. I tried installing the 32bit version of 2014 run time as the 64Bit did not work out. Thanks

Hi All, Was wondering how i can import data from a file to a table in different fields. The data inside the file is described with the number of characters and space's between. The attached file has the data. For example in the file attached, the first four characters represent a data like...

hi, Is it possible to add new records to a linked table ? i tried it out but new records is not possible, is there a workaround for this. Thanks

Hi All, Need a little help with adding a date stamp on each line inside a text box when the form is opened. i've managed to add this expression to the text on got focus =Date() & "/" & [IncidentDetail] This every time adds the date stamp to the first line of the text box and not below the...

Hi All, Was trying build security feature with Dlookup and tempvars. I've got a call log system where there is a check box if a followup is required. My idea is, if the [AttendedBy_FK] and the [Tempvars]![TempEmpID] are equal in then the Check box (chkFollowup) is enabled else it should be...

Hi All, Was trying to use a button to apply a filter from a form to a subform the subform (frmLogOverview_Subform) has a field call AttendedBy_FK and I wish to filter this from the main form (frmCallOverview) how can I do it ?

Hi All, how can I prevent duplicate records from being added from a form, the dcount in the text field property, trigged before update is where this should be used is what I know but having trouble with the syntax. I've got the table tblInvnetoryDetail with InvID(AutoNumber), and...