Recent content by w0od0o

thank you :)

Hi, i have a query to find all jobs with a completion date within the next 7 days with the following criteria under "completion date" but it doesnt seem to filter correctly, i thought it worked correctly on a test database but when added to the final database it seems to produce all records...

hi, is it possible to export through vba a single record and add it to the next blank line in excel? thanks w0od0o

thank you i assume if i want to add some "-" in between then it would be DirName = "F:\test\" & Left(Me!contract_number, 10) &"-" & Me!Client &"-" & Me!site thanks again w0od0o

Hi, i have the following to create a directory Dim DirName As String Dim Response As String DirName = "F:\test\" & Left(Me!contract_number, 10) If Dir(DirName, vbDirectory) = "" Then If MsgBox("OK to create folder!", vbOKCancel) = vbOK Then MkDir DirName Else MsgBox "Create folder...

hi Mr. B, it seems to work fine but with one slight problem, it appends the data fine but for some reason it assigns the same job number to all that you append rather than each job having an unique number, also an additional favour, i have added your method to append any extras to the contract...

sample data added, i have added 1 quote and then added that quote to contracts, as you can see in the jobs table it has imported the job but with a blank job and no job number thanks w0od0o

sorry my fault again :S, the import jobs button is on form "contract_view" to import the extra jobs and when adding a quote to contracts the form "contract" runs the query "append_jobs_quote" on load, hope this makes sense w0od0o

sorry probably my fault as i removed all my test data, if you add a quote to contracts then it appends the "quote_details" to the "jobs" table, also if a contract has been generated and additional work is assigned then "extras" is appended to "jobs" by clicking the import jobs button on the...

hi Mr.B thanks for that, from what i can see you have changed the code on the contracts form which makes a lot more sense than what i had although the problem i am having is assigning a "job_number" to the jobs table when i import the jobs from a quote. many thanks w0od0o

added database,

Mr. B i have tried what you suggested but after adding the appended data it assigns the next job number to a new blank record :(

Hi, the problem i have is i have a main form "contract" with a subform "jobs" i have an append query to add the job details from a quote to contracts which works fine but i cant get it to run the following vb Me.job_number = DMax("[job_number]", "jobs") + 1 it works fine if i add the data...

hi, i have created a form with 3 combo boxes on to filter through to a desired quote, i can get it to filter through if all fields are filled in but if for example there is no site name then i cant find the quote number. at the moment i have in a the sql builder [Forms]![add_quote]![site] &...

works a treat, thank you :)