Search results

I guess i do need the data to refresh, but while keeping it on the current record. It refreshes fine when i have Yes (Duplicates OK), but when i change the table to Yes (No Duplicates), it doesnt refresh. Yes i tried your suggestion with a requery, but quickly realised that it will only work...

Both ID fields are text fields with an alpha-numeric input mask. Unfortunately the form data that needs refreshed/requeryed is not within a sub-form, so if i requery the main form, the form skips to the first record.

Hi Apologies in advance...my VBA/module knowledge is at an early stage! I have successfully linked two SQL tables with a AutoExec macro, using the following vba code: Public Function SQLlink() DoCmd.TransferDatabase acLink, "ODBC Database"...

Hi I have the field ID.tableA field linked by a left join to ID.tableB field which is in an ODBC table. The index setting of ID.tableA is Yes (Duplicates OK), and the index setting of ID.tableB is Yes (No Duplicates). I have the query set so that when i type in a correct value in ID.tableA...

but what if I want to use this textbox as a value because it will still appear as zero in the table??

I know this is an old query, but where would I put the IF statement from charityg?

I have a tick box called [weekend_full] which when checked should insert 150 into the field [Fee amount]. I have came up with the following code: =IIf([weekend_full]=True,[Fee amount]=150,[Fee amount]=0) This obviously doesn't work. What is the correct code & where should I insert it? Thanks

Thanks mate - i feel stupid!

I have two fields, one named course code and one named requisition number. I have both of them in a text field: =[Course code] & [Requisition no] Requisition number is an autonumber with a format of "/000" The problem is that if course code = 185 and requisition number = 010 it displays...

Hi, I have a text field (field1) which takes data in the following format: S75-24-185-140 But i wish to have another field which creates an invoice number (field2) based on the 185 part but also combines autonumber eg: 185xxx with xxx incrementing from 1 to 999 Maybe i havent explained...