Search results

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

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

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