Recent content by Greyowlsl

Works, thanks! The first piece of code is what originally tried. However I noticed you put "yyyy" instead of "yyy", I'm suspecting this was the problem all along :banghead: ,Leon

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

Used and tested the SQL code and works perfectly! Thanks so much for you help Galaxiom! Kind Regards, Leon

Unfortunately I'm running access 97, and it cant run your example. However, I ran the query with the outer joins and null (as shown in the picture), but i also added the fields from the SubQry, so now i can see all unique record combinations that are not in the allocation table (which is a good...

Hi Galaxiom, Thanks for your reply! The first query worked, however im still unsure how the outer join query works. Here i have an example, where the outcome is just a large number of completely blank records... or maybe this is the right outcome? question is then how do i populate it...

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

Tested it and it works. Thanks!

Hi CJ, Thanks so much for your reply. It was as i feared. With the tlbProducts, what would it look like, what is the p-key? tblProducts Product -PartIndex -Quantity Product 1 -1 -1 Product 1 -2 -2 Product 1 -3 -3 Product 1 -4 -4 Product 1 -5 -5...

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

Could be, it doesn't seem to be doing it on other faster computers, but i can't really take any code out. Thanks anyway.

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

So i found this piece of code on a forum, was wondering if someone could help explain how to use it. Private Sub Command1_Click() Dim strSQL As String strSQL = "UPDATE " & Me("MyTextFieldWithTableName").Value & " SET MyFieldNames = MyNewValue" DoCmd.RunSQL strSQL End Sub Table name: Table1...

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