Search results

I am developing an application for tracking swimming pool data. The logic has split the client details into two parts. The client personnel data and the pool address data, as the client can move, but the pool does not. In some cases the client can have more than one pool, and this structure...

I think a finished product table is required it would have three fields Finished Product ID, Related ProductID and Quantity. HTH

From what you have said you may have 10 boxes, with up to 10 items containing contract details. Does this mean you can have 10 contracts in any one box? What exactly are you trying to do?

This is SQL statement I want to manipulate in VBA: "SELECT [ClientName] & " "& [PoolAddress] AS ClientDetail, " & _ "[FirstName] & " " & [LastName] AS ClientName, [StreetNumber] " & _ " " & [StreetName] & " " & [RoadType] & " "& [Locality] & " " & " & _ "[PCode] AS PoolAddress...

I have two forms set up. The first form is a client job booking form. The second is a kitset job form. If you choose you can add a kitset job to a client job. When you click add on the kitset button form ADO updates the underlying recordset for the stock tables and updates the field for the...

I have a subform which is linked on two fields, to the main form and this sort of achieves what I want. In that when I select from the combo box the form is loading if there is a matching record to display. Ideally what I would like is the form to load at all times and if there is no match to...

That's because criteria are not empty strings if they are not present. Try this: (nz([forms]![frmGeneratorSearch]![combo2], IsNull()) or a derivative of it.

Have you considered using a mix of tabs and subforms. You could set up a field on each tab that is populated with the SupplierID or similar and then create subforms that are linked to this field.

Is your subform based on a query that is getting values from your form?

(nz([forms]![frmGeneratorSearch]![combo2], "") Will give you a criteria of "" or combo2. Isn't this what you want.

So some items are $4.00, $5.00 etc and some items are $3.00 but if I buy a $3.00 item I get four more for free? You need a second table to do this. The first table would look something like: ItemID ItemDescription Price The second table would look something like: ItemID(From Table1)...

I found DateDiff works well for calculating the gaptime in minutes. Is there a problem with that approach instead of DateAdd?

Yep, that'll sure help. Thanks a lot.

I have the following query. SELECT qryServFindNextAvailableTime.JobDate, qryServFindNextAvailableTime.ServPerson, First(qryServAllStartFinish.Start) AS FirstOfStart, qryServFindNextAvailableTime.TimePromised, CSng(DateDiff("n",[Start],[TimePromised])) AS AvailableMinutes...

In code on the current event of the form: if myfield<DateAdd("d",-60,Date) then MsgBox "This is expiring" End if

Okay, I have a form which shows the service persons. When you select one I have a query which goes and finds their next available start time and suggests this as the best time for the job. If you then enter a duration which goes past the end of the day, by default the form defaults the start...

If you are leaving the main form open and pop up the other forms you could set the default values for the fields you want automatically completed to be =mainform!case#. Use the builder to get the right syntax.

I haven't really thought this through, but you could change your recordsource to a query, make the query fields your autonumbering field.

One approach maybe to alter the structure so that the two factories have seperate tables and these are related to the record. tblFactoryRecord IDNumber tblOtherFactoryRecord IDNumber Relationship MainRecord - tblFactoryRecord MainRecord - tblOtherFactoryRecord Looking at your code and...

If you really want to do this then in the data entry form you could have a hidden text box sourced to the field and when you click the close button update your field to the value you want. However, in Access you normally do not stored calculated results in a table, rather you calculate as...