Search results

I have created a query, and one of the columns in this query is called number. I've set this column to a combo box, and the choices in the combo box are called from a number table that has the numbers, 1,2,3,4,5,6, etc. If i create a new entry in my query, then the number value defaults to zero...

Thanks again Brad, you've helped me out yet again. I suppose it doesn't matter about the file being public, after all these forums are about sharing info, right? thanks again, Bakerboy

I don't know much about the percent format, but I do know that if you want to write a percentage such as 14% in decimal form then it is equivalent to 0.14. "Percent" means "out of a hundred". That is 14% equals 14/100 = 0.14. So maybe this percent format requires entries in the decimal form...

G'day brad, Yeh, it's the same form, I think I've renamed the text boxes though.

Sorry, it appears that the way I formatted the report layout did not work once I posted. For the first entry of the report the TOP FEED is Switchboard 1. The LOWER FEEDS are Load 1, Switchboard 2 and Substation, with their respective powers. And so on for the others. Sorry the formatting came...

Report that sums values in order I'm currently trying to design a report that sums all the power flows in, say, a power plant. I'm having difficulty deciding how to set it out. Firstly I'll try to describe what I hope to have in the report: In a power plant layout, the different levels a...

Thanks for your replies, I've set them up as fixed numbers. I've made sure all boxes are set to this. Also, the error I get is "#Error" in the box.

This is most likely the easiest thing to do but I CAN'T DO IT!!!! I have two text boxes, "Tot_Length" and "Cap". I wish to subtract "Tot_Length" from "Cap". I've tried the following in the control source: =[Cap]-[Tot_Length] This does not work. If I put just =[Tot_Length] then it returns the...

Hi again brad, i've whipped up a very crude version of the original. only problem is that it's too big by only a few bytes to attach. is there maybe an email address i can send it to instead?

I appreciate that offer. But the db is secure and I can't copy it, and its 37meg as it is. I'm trying to take out the relevant bits and whip up a quick db. may take a while though. If you don't mind i'll still send it when I get that done. Thanks. ps: it 3:50 pm on a friday for me..... I...

Thanks again but I'm afraid that this did not work. In design veiw, the code I typed into the control source just appeared in the text box. In form view it's just blank. I got no idea why....

Yeh I tried that also but nothing different. Thanks anyway. I did notice that now I'm getting the error that it can't find the macro me. I don't understand this. By the way I like your picture bradcccs. Go Aussie!!

I somehow got the list box to work once. That is, it produced the correct answer when I opened the form, but then the answer stayed the same no matter what I changed or clicked. I figured that adding the line you suggested would help this (makes sense), but for some reason it didn't. Can you...

I don't know how to do that...... so I'm guessing no! :-)

The form I've created sorts cables into drums. On my form I have a list box called "Capacity" which gives the capacity for the selected drum, and another list box called "Total_Length" which sums the length of the cables in a particular drum. When the total length value exceeds the capacity...

I have created a form called "Cable_To_Drum". This form has a list box called "Cable_Code_Box". I am currently creating a list box called "Drum_Same". I have a table called Drum_Table which contains various columns, two of which are called "Cable_Code" and "Drum_Number" respectively. The idea...

Does anybody know how I can create a text box, or label box, or something that displays a message only if certain criteria are satified? Something like a text box that is only active if something is true.

Thanks again!!! : )

Sorry, just one more thing.............. How would I create a button that adds a new drum to the drum selection box? Thanks :-)

Hi dcx693, Well the list I was trying to sum has since been modified due to some really good help I got through these forums. The help I got was in a post called "add remove buttons". The person who helped me, Tiro Cupidus sent me an example file called drumscables.zip. This is now the...