Search results

Thanks Thanks, Its exactly what I needed. I wish I found it months ago. Cheers.

Hi, I have code for a Open Dialog box, But have been unable to find code for a save dialog box. Attached is an example of the code I have for a Open Dialog, If anyone has a save as Dialog or knows how to covert the code to a save dialog please post. Reagrds, Todd

Hi, My way to working out where the error is, is to first take the output from the Debug.print and place it into a query. This should give you a more detailed error on what is wrong with your SQL. Todd

Hello, I want to be able to pass arguments to an access file on start up. I want to be able to grab this value and then perform an action based on this. Background: The program will send an email with details for a change request, the recipient will then need to click on a link to...

Hi, I want to be able to find out what record was updated and I need to then log some details to another table. If I use the Form_BeforeUpdate event to detect that the recored will be updated, then How do I find out what record was updated. Thanks, Todd

Hi, I have images that need to be displayed on a form of varing sizes. I am currently using the bound object frame to display them (Zoom format). But they do not center. Is there an image control or a work around to get the images appear centered. Thanks, Todd

Thanks alot, working well so far, save a huge amount of stress. Cheers

Hi, In one of my tables I have an alphanumeric field that we now need to sort by. the usual values in the field are like: 1, 5a, 10, 10a, 20, 50a, 50b, 999 Using order by will sort 1, 10, 10a, 20, 5a,... Is it posaible to use some sort of format or filter in the sql to only...

If you want great front ends then I would say VB.NET is the way, its a programming enviroment. Database access takes more effort in VB.NET but if you were using it often you would get use to it. Access is simple and quick for databases. Thats what I reckon, Todd

Try strName = "Query2" strQuery = "SELECT TableAdress.Checked, TableAdress.EmailAdres FROM Query1 WHERE (((TableAdress.Checked)=Yes) AND ((Table.EmailAdres) Is Not Null));" Set qdf = db.CreateQueryDef(strName, strQuery) group = inputbox("Enter the group name.") while not qdf.eof sql =...

Are the data type of the numeric fields stored at Text or Number. It looks like they are stored as text so it is joining the strings. If you are doing the adding in VB, you could try cInt(Cargo1) + cInt(Cargo2) + .. Todd

DoCmd.TransferDatabase( see what you can find, or some one else with an example may post aswell.

"UPDATE ProductTbl SET stockLeft = " & yourNewValue & " WHERE productID = " & theProductID Could you place that sql statement in a module or form at the point where you need to update the value.

Try formatting the date in the DLookup. checkalloc = DLookup("allocationID", "allocation", "nightrent < #" & format(CDate(currpost),"dd mmm yyyy") & "# AND status = 'current'") I do the same thing when saving dates, so that I dont get a US date which stuffs things up. Todd

I think this is how it is done, round(weight + 0.005,2) The + 0.005 is so that if the weight will round up if above 7.455. Todd

try using openArgs, you can pass a variable when you call the openForm event. Do a search and see what you come up with, you would then use this value on the Form_Load event to disable the button if required. Todd

Easy I think. Im not to good with dates but there will be help around here you will find with a search. sSql = "UPDATE membersTable SET status = 'inactive' WHERE lastActive < #" & now() - 2 years & "#;" currentdb.execute sSql the date syntax will need to be looked into. To run this on...

sSql = "DELETE FROM turkeyTable WHERE turkeyID = '" & cboBox.column(2) & "';" currentdb.execute sSql Is this what you are looking for, cboBox.column(2) would need to relate to a turkeyID. Todd

have you placed the code DoEvents where all the work is been done, this will stop whats its doing there, do the timer event which is waiting and then it will return to what it was doing. If the code is not in a loop, you will need to place DoEvents through out your code I do belive. Just...

thats for that. the ! solved my problem. Now I only have to deal with key violations :rolleyes: . Cheers