Search results

Hi guys, I'm trying to use a very basic datediff function to show the number of years difference between the current date and the date in a text box. I have look on many forums and tried so many different things. I am a beginner coder, but I have no idea whats going on. Here is the last bit...

Hello, I have 3 tables: Product Part Allocation The Allocation table has 4 fields: Pkey (Autonumber) Product_Index (Index from product table) Part_Index (Index from part table) Quantity (Manually entered) When I create a new part (with new part index) I need a record created in the...

Hello, So i have a table with Columns: Index, Part, Part cost, Product 1, Product 2, Product 3... 'Index' is the unique no. for each part. 'Part' has the names of part. 'Part costs' have the cost per 1 part. 'Product'# have a number of how many of that part is used in that product. I am...

Just getting some idea on how people feel towards their government, not specifically just the spokesperson (president, prime minister etc.)

Hi, When moving to a new a record in my form, i will click on a text box and the following happens: The black line will flash much faster than normal (This will happen on any text box i click on) No text will appear while this is happening When it stops al the text that was typed in that...

Hi, Ive got a form that has Customer infomation. Basicly i select a customer from a combo box and it loads up their record. What i require is that when i open a customers record, that i can enter alot of info about the meetings i have with them. My first solution was to make a new table with...

Hi, I need a query's field to change to what is selected in a combo box. Example, I select product 1 in the combo box on a continuous form, after the update there is a requery. The form now displays the data from product 1. I have tried putting [forms]![form1]![combo1] into the field box of...

Hi, As stated in the thread title.

Hi, Ive got a database with a combo box, called "combo1" (with 2 columns). It is unbound but uses a query as its row source. When i select a value in combo1 is places the data from combo1.column(1) into a textbox (text1). I then click the next record button (button1) and it then keeps the same...

Hi, I have a form that has a combo box (box1), Its row source is from a table (table1) than the forms record source (query1). The data box1 sources is from column1 in table1. I then have a text box (box2). I need it so when i select a record in box1 (from column1) that it displays the...

Below is some code, which i can't understand what its doing, or what some of the commands mean such as rc.fields(10) etc. I just need someone to shine some light on what the process is here. Below is the form current code for a Purchase Orders Form (this form also contains a subform called...

Hi Guys, I didn't know where to post this, but i figured some VBA would be needed somewhere. Okay so; I have a table 'PARTS', below is a small example: PARTS PART MODEL A MODEL B X 5 6 Y 6 7 Z...

Hi, I have a form which has a number of text boxes that need their value multiplied by their corresponding value in a query. The query has a product field, and a product count field. Example: Text1 has a label called wood1 (the product), so i need text1 to lookup wood1 in the query (product...

Hi guys, Ive been getting that error (thread heading) when trying to run a query The query runs when i open a form, is there anything wrong with these expressions? Date Rcvd Field Between (DateAdd("m",([Forms]![Repairs Recent]![text16]),Date())) And Date() Product Type Field [Forms]![Repairs...

Hi, I have a text box with a memo control source, when you click the text box an acCmdZoomBox is run. However when the Zoom box opens it highlights all of the data, which is causing issues with people accidentally deleting all the information. I have seen something about a selstart, sellength...

Hi, As you can see in the thread heading, i have an issue where i am trying to change a text field into a memo field, but i get the error "There isn't enough disk space or memory", so i changed the MaxLocksPerFile in the registry by following this http://support.microsoft.com/kb/209940 However...

Just wondering what computer software savvy people think about Energy sources, now and in the future. Whats your prediction? What would you like to see?

Hi, I have a combobox where its record source is from 'table 1' (the form's control source), however its row source is from 'table 2'. I then have a number of text boxes which also have 'table 1' as their record source. What i need is that when i select a value in the combobox, that the...

Hi, I have a query which has 3 'where' fields, a 'group by' field and a 'count' field. The 'where' fields each have a criteria that refer to a form ([Forms]![Forecast_Update]![text17]), on the form is a button that runs the query (once the text boxes are filled), the query however shows up...

Hi guys, Thought I'd try this again, in a different forum topic. For reference an inverter is an electronic device used in solar systems. First... I have a form (PARTS FORM) with a combo box (PART) and a bunch of text boxes for each type of Inverter. When a part is selected, each inverter...