Search results

ive added a MsgBox to ask to save the file? this should allow the time to create the folder?

yes!!!! you two are smokey :) ive added pauls line to a new button and works fine, when u say add a pause, whats the code for that? Thanks both, very appreciated. w0od0o

Gary, the code works great to add the directory thanks, but im still struggling to save my report in that directory as it isnt created and i would like each report to go in there own folder w0od0o

i have set referntial integrity, but at the moment whether its undo or delete it onlt removes the data where the cursor is, what i have is a query that Dmax's a quote number on load and i want all associated data removed if the user decides that they dont want to continue. thanks for your...

yes i think so, would this create a folder: F:\test\1234 <----sample but is it possible to save a report in that folder? as i can only get it to save in a folder that already exists thanks w0od0o

so are you suggesting i move the cursor to the record holding the sub-record and this will cascade through? so dont want to spend hours trying to figure it out

Hi all, I am trying to create a cancel type button that will remove data that has been added so far, my problem is i have 2 queries on 1 form and i can only seem to get it to delete the records associated with the query that the cursor is in (if that makes sense) All help welcome w0od0o

Hi all, i am looking to create a directory named from a field in my table and then add a report to that directory, i can create a directory but not with the name from the field and i can also export the report but not to the directory i created heres what i have so far Private Sub...

sorry for the delay ive been away, i dont really know much about code only what i have pick up on here, it seems to be working again now for some reason but i havent changed anything since i posted, th reason i know it wasnt working was because it runs a text box after to confirm its done, ill...

hi just a quick post hopefully :S, my database seems to have all of a sudden disabled the vb code? all worked fine and still does except that any code i wrote myself (very basic stuff) doesnt run any help is appreciatied thanks

thank you both, i seem to be able to get the above working with some modified tables and forms but as soon as i run my database from my switchboard it wants to restart the number from 1 again, any ideas? sorry got 2 posts mixed up heres my code from the link above Private Sub...

i thought as much tbh, was something i left untill the end and when i looked at it changing it i realised it wasnt meant to happen :( can i auto increament other fields?

hi, i am looking at rather than having 1, 2, 3, 4, ect for my autonumber i want to auto assign a certain alpha/number ID such as ABC0001 i would also need this to start at a number later in the sequence such as ABC0456 all help is appreciated thanks w0od0o

got it thanks :)

thats fine but doesnt the form have to have a query behind it with the relevant criterias on it?

i have a query with all my invoice data in and i am now looking to filter that query by several methods such as by contract, betweeen dates ect but i am un sure of the best way to proceed, would it be to have another query to filter by date and another by query which then in turn opens the final...

thank you very much, works like a dream :)

that would work fine if i think if i invoiced per day but where i would work say 5 days on 1 contract i get multiple lines in my invoice query because the data can not be grouped, if that makes sense :s

Ill try and be as clear as i can although i find explain these issues as hard as solving them ;) i have created a form with a drop down list of clients to find a specific client to edit the data in another form, all this works fine as long as the form with the dropdown list on is open first...

no its to show on an invoice, another way i thought of my work easy but still not to sure is if i had: 12/01/09 - i did this 13/01/09 - i did that ect.... but i am still unsure how i would do it :(