Search results

Hi, My linked table has a field called REFNO which is a reference number for each record (autonumber). When i use a form to add a new record, it shows (autonumber) in the textbox and the following error: "you can't assign a value to this object. *the object maybe a control on the read...

Hi, I have tickboxs on a form im using to add / update records in a linked table. When the tickboxes are selected the set the field in my database to 0 or -1 instead of Yes and No. Is there anyway to change this to Yes and No? Thanks

Ive discovered that this overflow problem only affects those where the corresponding received and completed are 0 so could this be the divide problem you mentioned earlier? Least im starting to see what to concentrate on

tried using just Int instead of CInt to see if that worked before considering the NULL factors yet still the same error occurs about overload. Maybe i could send a blank database with a table and the form for someone to look at?

That works exactly as requested, thank you so much :)

In the Ratio cell i have the following control source: =CInt([txtCompleted1])/(CInt([txtCarriedIn1])+CInt([txtReceived1]))*(100) And included a format of fixed and decimal places of 0

As far as the colour aspect works, its great, yet io keep getting an overflow error on the Ratio, im guessing because im reducing the % worked out to 0 decimal places. Also shows #Num! when vales are 0 unless thats something to do with the sum im suing :x Any workaround?

Still not able to specify the Log reference but believe it now to relate to the value being a number as i added a date column and tried that which also shows an OpenForm error yet anything with text seems to link to a record no problem. Really need it to relate to log number though :(

I understand what your saying but i mean for the if statements with the Ratio, i.e txtRatio1 txtRatio2 txtRatio3 and txtRatio4 text boxes, applying the same colour change if statement without useing 4 statements.

Sorry, its a general question as if possible maybe something i could incorperate into my current project.

Hi all, Just wondering if this is possible, to create a button on a form that will, in essence, printscreen the form BUT also save as an image and place the file in a specified location? Thanks

The above works fine, and upto now ive tested it a lil without coding the calc straight into the code. Just a final little question, as i have 4 cells, id like to integrate the wildcard into txtRatio as to not have a procedure for each Ratio cell but i cant get * to work :(

Tis i form that i will be using to generate a summary, i used the term report in relation to what im using as

The way my form works is 2 fields pull in values form a table, with the ratio working out the percentage. It is a report s no values will be manually edited so with i assume change the first line to read?? Private Sub txtRatio1_Form_Current(Cancel As Integer)

Im a little confused with what you mention when you say: "In a Single View form your code needs to be in the txtRatio1_AfterUpdate event and in the Form_Current event, not in the Before_Update event.In a Single View form your code needs to be in the txtRatio1_AfterUpdate event and in the...

Im afraid conditional formatting doesnt exist in Access 97 (of which im using, bit of a relic :x)

Hi all, Have a problem with a textbox in a form! I have several static textboxes which relates to a field inside linked table. In each of these i want them to change the text colour if the value is 100. Ive tried the below but doesnt work, assuming that syntax is slightly different for form...

I dont understand, as '" & Forms!frmViewUserList!lstResults & "'" already indicates its set as the ID, the problem appears to stem from "[Log Reference]= but i cannot be sure.

Its ok, i solved it (edited post at same time lol). Its because i had changed the first value in the SQL statements to [Log Reference] and Forms!frmViewUserList!lstResults takes the result of the first value in the statement. It all works fine with Owner as the first value , but now that i...

Thanks for that, as the result was showing name i didnt figure that was needed :x.