Search results

final solution this seemed to work if anyone's interested: Private Sub Form_BeforeUpdate(Cancel As Integer) With Me If .NewRecord Then If IsNull(Room_Number) Then .date_stamp = Now() .Export_ctrl = "4"...

what is the correct syntax for this... I have the following and it doesn't work - If IsNotNull(.Room_Number) And .Export_ctrl = "4" Then .Export_ctrl = "1" can anyone enlighten me on my error - i get the 'Compile Error, sub or Function not defined' many thanks for whoever...

On Monday the 1st of September Robert Hyde (self proclaimed intellectual) wrote: Can I add another IF e.g. If .export_ctrl = "3" And IsNotNull(.room_number) Then .export_ctrl = "1" I've tried this but there's something wrong with the syntax. *says to himself "I am getting better at...

thanks but I have a problem I have used this code and I can see the logic behind it yet I have the following problem that may hinder the export action If i enter a new record with no room number my export_ctrl field says "New un_Allocated Room" If I then allocate a room to this at a later...

hi folks I currently have the following code on a form: Private Sub Form_BeforeUpdate(Cancel As Integer) With Me If .Dirty Then If .NewRecord Then .date_stamp = Now() .Export_ctrl = "1" Else .date_stamp = Now()...

yr right I just figured that out myself thanks though

I know this is something to do with refresh/requery I've added me.refresh and me.requery to the 'on open' procedure on the form but this only seem to effect the first - as i cycle throughthe records they do not all refresh - therefore I think i need a procedure that refreshes/requeries each...

hi I've developed this form that contains some cascading combo's. They work fine and the data gets written to the master datasheet etc... HOWEVER... when I go back to the form - the data in the fields controlled by the cascading combos is NOT (always) VISIBLE for every record and when I...

it's okay solved it by substituting 1 for YES in the xpression thanks for your help :)

thanks again the query now runs without error messages - yet I don't get a value of "A" in my new DATA_CON field?! YES does = 1 doesn't it?

type mismatch when I try to include the the expression in my export query: DATA_CON: IIf([Accom_record_card]![Data_connect]="1","A",Null) I get Type Mismatch in Expression error... is there any way around this?? :confused:

thanks... I'll give the export Query a makeover and see if that works... "I might be back" as a confused Arnold Schwarzenneger might say

i have searched for this but not really found anything similar: I'm sure it's dead easy but I want my check boxes on my form to store codes instead of '1' or '0' for export purposes. eg. a check box for Data Connection? (YES/NO) would store code 'A' if checked and ' ' (ie. null) if unchecked...

howdy folks what i want to do is have a msg box appear when a user clicks a button to Export records. the message box will say " You are about to export (x no. of records). This will update the current data base. Are you sure you wish to continue?" x will get it's total from a count query is...

hi eggwater guess what you sorted it yrself you clever bastard ha ha *goes to pub for celebratory beer and dance with complete stranger*

I've been given this job to do at work where I have to steamline this database (a flat table created by someone else) so that I can automatically export Standardised data to an all singing and dancing SAP system. I have done all the relatively hard work (with a little help from this Forum I...

spot on cheers pal!! it works a treat that looks a lot more pro than what i coded (although it did appear to be working) excellent

this was my code Private Sub Form_BeforeUpdate(Cancel As Integer) Me.date_stamp = Now() Me.Export_ctrl = "2" If Me.NewRecord Then Me.Export_ctrl = "1" End Sub it doesn't accept an end if does this matter?

this is my code it appears to be working actually

sorry to be a pain but how does that code fit with my original code I'm not too familiar with VB (if this wasn't obvious!)