Search results

Hello All, I have created a form which allocates cables to drums. This is based on a table called "Cab_Sched_Temp" which has a "Cable_No" field and a "Drum_Number" field. Basically, the way it works is that within the form I have a list box with a list of Cable_No's in it, and a combo box with...

Hello all, I've made quite a few reports for my company and each one has the company logo stored in the report header as an image. I also have a job title and number in the heading that just describes the current job. The problem is that firstly, I've added the logo top every report and...

Hello All, I've created a query that resets a table entry called "Drum" to null if I change the record "Cable". This process works, except I get the following error when I do so: " Write Conflict This record has been changed by another user since you started editing it. If you save the...

Hello All, Hopefully this one is not as difficult as my previous post. I have a query, and I would like to add a column that checks to see if another column called Drawn is null or not. If it is null, then in the output of my query, I would like to see an unchecked checkbox, and if it isn't...

Hello all, I have a table at the moment that has the following columns: Parent_Tag, Child_Tag, Value and Level. This table represents a tree diagram. The Parent_Tag is the name of the level connected directly above the Child_Tag. The Child_Tag has an associated Value and Level. The Value is...

I'm trying to create query based on a tree diagram. I have a table with the following info: "Upstream_Feed", "Level_No", Tag_Number" and "Power". Upstream_Feed - ID (Tag_Number) of level connected directly above Level_Number - current level number (top = 0, next is 1 etc..) Tag_Number -...

Hello All, I was trying to design a query that looks up values from a table and allows the user to select from a combo box. This part is farily straight forward. I would like to extend this so that I can also type in a value into the combo box, and have it update the table it was choosing...

I have a report which is sorted by Level_No. If I have summed a total for say Level_No 3, then can I use this result when I sum a total in Level_No 2? For example, the result of Level_No 2 may include certain values as well as the total from Level_No 3.

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

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

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

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.

I have a list in a form which has been generated using a query. I would like to add a box at the bottom of this list which sums the contents of the list. I've created a button i press that cycles through different lists, and I would like the total at the bottom to update every time I choose a...

I was hoping someone out there could help me with creating an access form that can allocate cables to various cable drums. Basically, I want to display two lists. The first is to display a list of cables that I have not yet added to a cable drum. The second list is to show a particular drum...