Search results

Clarification Thanks for the reply.. The query that contains the data may have many repetitions of the same ID number, for instance ID2001 may occur several times with different customer names and Types. I want to keep all these records I also want to keep records where Type = 'Promotion' if...

Hi all, i need some help constructing a query that will create a table for me that does not include the Type value of 'promotion' if the same ID value exists elsewhere within the query. For instance, in the example below, i would want to delete the first entry containing 'Promotion' because...

I have a folder on my PC C:\PICS that contains JPG's in the format of AAAA_1_B.JPG where AAAA is the name, 1 is the issue number and B is the Type. I typically have about 10 pics at any one time in this folder. I want to create a table in my access app that lists all the JPG's within the...

Guys, I need some help with the attached timer database. I've used some code samples from this website to put this together, but I'm having a bit of difficulty with the logic.. when you see the code you will understand what i mean. What i want to do is enter a masterseconds value, and from this...

Hi all, i trying to design a date / time (hrs:mins) down counter. I want to put say my holiday date e.g 27/07/07, and then the access form will show how many days hrs and minutes left from the present date /time to the start of holiday. How can this be done easily? Thanks

Hi all, instead of doing a dlookup via a query, i'd like to do a dlookup for price direct in a table where the criteria is the value in Text1 from Form1 outt = Nz(DLookup("[Price]", "Table1")) Where Product = ' Text1' from Form1 Whats the correct syntax for this please? Thanks

re: Col, DoCmd.GoToRecord , , acLast docmd.RunCommand acCmdDeleteRecord How do i point to the table i want to delete from with the above? Cheers

re: Hi Colin, Its basically a shopping cart, with goods added to the cart table when the 'add to cart' button is pressed. I now want to add a 'delete from cart' button so it deletes the last (bottom) record in table. I simply want to select last record and delete. No other parameters needed. Cheers

Hi all, whats the simplest way to delete the last record in a table? based on DoCmd.RunSQL "DELETE * FROM Trying to use a button to do the above Cheers

Hi Bob, The table i'm trying to write to is not bound to the form, (the form is bound to another table) and that's my problem!... Any suggestions ?

Hey all, With the bit of code below, i select a vendor code from my dropdown list, and then two textboxes lookup the supplier name and telephone number via a filter in my query "supplierdetails" and it returns the values to my form. The query "Supplierdetails" gets its data from a table called...

re: Thanks Neil, and i totally understand your logic. When i tried it and it worked for some combinations, but it also behaves weird, for other combinations. The query sometimes shows the whole table....:confused: any ideas?

I am trying to get my filter query to work properly, but its not quite there yet! Here's the Query Criteria Like "*" & [forms]![myform].[Grp] & "*" And Like "*" & [forms]![myform].[Grp2] & "*" And <>"MICK" Basically i want to have my query filter records with a value in Grp, Grp2 or a...

Hi rainman, i do have an invisible text box on my form with its default value = date(). When i hit the save button on the form, I want to write the current date into column SentLast for the current filtered employee in the query. I am guessing i need to use Insert into table or a update query...

Hey all, I have a form that is bound to a table called "mytable" I have a second table called "lastsent", In here i have two columns PersonName and SentLast. The form contains a combo box with all the employee names and when a name is chosen from the dropdown, the after update runs a...

Thanks Guys! Wayne, The 10 second is so i can see the result occuring. Thats it :) I have a problem with the code sniplet. it says "Too few parameters. Expected 1" I am loading the Name, address and phone from a query called "persons" so i have Dim rst As DAO.Recordset Set rst =...

Gooday all, i have a table that consist of 3 columns, name, address and telephone number. The table consists of about 20 records. What i would like to do is simply show one by one all the names from my table sequentially upon clicking a button on my form. I dont mind if its shown within a label...

Hi all, i need some help to re-format dates in a spreadsheet from US to UK. The attached Dates.xls contains the US style date format So far i have the code below to open the spreadsheet, autofit the columns, and set the font size to 8pt. Just need some help with the date re-formatting. Can...

Can someone help me with this filter query problem i have? My query contains a criteria [forms]![buyform]![Grp] Grp is set up as an invisible text box on my form called 'buyform' Problem i have is i want to be able to sort my query records using multiple variables. For instance in my code...

hey all, i have a supplier table (Supplier), that has a yes/no check box column field depending if they are active or not. About 200 suppliers in all, many of which not active. I want to be able to automatically set the active field to True within the supplier table depending on the condition...