Search results

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

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, 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] &...

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...

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...

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

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

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...

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...

hi, is it possible to combine dates and text fields into one field, lets say i work on 12/01/09 13/01/09 and 14/01/09 and want to show those dates in one field as dates worked, and while i was there i worked: i did this, i did that, and i did some more, i have set my queries up to...

when creating forms should i create them from my table or create a query first from my table then a form from my query, thanks w0od0o

i have created a query and formated the data to the first 3 letters of the month but they display in random order apr jan feb ect... is there anyway of getting them to run in month order jan feb mar ect... thanks w0od0o

hi, i have created 3 queries and now i want to create a 4th to filter all the data to certain dates ect.. but when i add all 3 queries into 1 using all fields in the queries i get duplicate data, i think it has something to do with the foreign keys but unsure on how to remove the problem...

hi, i am looking to try and get 2 fields in a table to add together and then show data in another field for examaple: cost + VAT = Total which would be the best way to do this, in a table, query or form? thanks w0od0o