Search results

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

thanks for your quick reply, it seems to work but a little bit random and i think its something to do with the records not being saved or the "select" data when selected not updating before i click to run the delete query, is there some way of store the data when i click the button? thanks...

Hi, i am try to create a delete query that will delete selected records, i have a jobs table with various data and a "select" check box, i have created a delete query where it will delete any record based on contract number and if select is ticked but i cant get it to find the selected records...

Hi, i am trying to add the data from a combo box to a different table on the click of a button, for example, im selecting a certain quote filtering through from client, location the quote number and i want to add a new record (when awarded the work) to contract unsing the quote ID (foreign...

Hi, I will start with a brief description of what i am trying to do. I am looking at trying to create a database that will track all my quotes and contracts, so i have created a table clients, quotes and quote details, then if awarded the work i would like to select that quote and generate a...

Hi all, I am try to show the data from a table based on a selection from a combo box which i assume is pretty simple but just cant find a solution. for example i have a customer table and a invoice table, when i open an invoice form i want to select a customer name from a drop down menu which...