Search results

I have a table linked to a sql database, I want to run a query that will only show certain depots but not sure how. i.e weston,london I can run a query that will work if I put in a single depot but I need a query that I can have serveral depots

Select new query Run unmatched query wizard

I wanted to be able to put it into a query if I enter a single contract number, it will sum the DHR. SELECT [daily revenue].[Contract ID], Sum([daily revenue].[DHR]) AS SumOfDHR FROM [daily revenue] GROUP BY [daily revenue].[Contract ID] HAVING ((([daily revenue].[Contract ID])=[enter])); I...

I have database where users can produce a quote. Each new quote gets a quote number, when users add a item to the quote, they also add a DHR (daily hire rate) The table records the item and adds the quote and the DHR I want to run a query so it shows the quote number and adds all the DHR's for...

I would like to know how

I have build a customized main bar can you change the font size of the text on the buttons

On a form I have a button that runs an update query, it updates records between to number on the form, can I get rid of the update message and replace it with "You are updating records between xxx to xxx" click OK and update

I have been asked to build a database to cost up a building job. i.e number of windows, doors, area of plot. Does anybody have any ideas on how to build this, I wanted to user to select each item from a combo box and then I would get added to a list the list then would create a report

Code so far Private Sub Command20_Click() Dim rs As DAO.Recordset Dim myWeek As Integer Set rs = CurrentDb.openrecordset("BDcontinue") myWeek = 1 Do While myWeek <= Me.weeks 'insert into table using either a recordset or Append Query rs.AddNew rs!EstDate = Me.EstDate + 7 * (myWeek - 1) 'makes...

If I take out the Jobcard date then how can I select between two dates on the form?. The list would be for all dates instead

I have been asked to produce a running total for companies we deal with. on a form I put two text boxes start and end dates and a listbox that should show all companies with work attached to them between these dates but the result is it shows the same company several times if work has been done...

Is it possible to set the percentage in the report preview before the report opens?

When i delete a record from a sub form on my main form, can you have the message say which record is being deleted i.e are yousure you what to delete item no 123

When i run this code, if the checkbox is not ticked it works. Either the Jobcard is complete and it shows the report or it goes to the control. But if you go to the control then tick it, then press yes for complete nothing happens can you help. If Me.completed.Value = 0 Then If MsgBox("Is...

I am building a simular database, the way I did it was I had a table for stock items, name,price,,etc and a table for stock amount joined by stockID When I produced a invoice I ran a query totalling the stock amount for whatever stock I wanted.

When i run this code, if the checkbox is not ticked it works. Either the Jobcard is complete and it shows the report or it goes to the control. But if you go to the control then tick it, then press yes for complete nothing happens can you help. If Me.completed.Value = 0 Then If...

I am trying to use your code, but the field on the subform is a combo box. This is what my code looks like If Me.subformquote.Form.Controls("Type").Value = "" Then MsgBox "Please enter a Labour type", vbQuestion, "Labour Error" Me.subformquote.SetFocus...

Can you change that if it is a subform. So on my main form if the user does not select a item from the subform the report will show zero.

I have two tables one holds jobcard info the other what stock was used with the jobcard. I have made a query from this and then a report. The report should show all job cards per company per week. It does show this but calculates the hours wrong. Because the two tables are linked when the query...

Yes, but each time I go to a post about HasData it says there are post here that explain this. I must not be looking in the right place?