Search results

Re: Access 2010 forum question There is a setting in the combo box properties that does what you want. In the properties of the combo box go to the Data tab, then Allow Value List Edit. Change that from no to yes. You then have to choose the List Items Edit Form. Choose the form. Now when...

If you want to update dates, don't think you'll be able to do it in a query, sounds like you need a main form for employee, sub form for entering training needed and another sub form for updating the training received. I've update the database with three queries (Geof_query 1,2 and 3) that...

I'm looking at the database on my computer which I have uploaded again. Totals for pay period 7, which is the last pay period on record contained in: "qry pay period linked to current" - total hours = 748, total rate 14810.54, 87 records "qry summary all" is another query from "qry by Pay...

No, my final query works. I'll take a look later.

Can you take my example and change the current pay period logic?

You never defined current pay period. Is it last week? Last two weeks? Current and last week?

Here is a solution, use the If statement in the macro if dcount("*","yourQueryName")<1 then stop the macro, else continue on I've uploaded a sample that is looking for more than 10 records in a query. Change my >10 to >2 and it will pull up the query instead of displaying a message box...

When I do calculations in the form footer, like average days and max of date, I do the following: Instead of creating another field that combines these calculations, I have to use the names of these fields, text1 and text 2. I've uploaded a sample that shows you what I'm talking about...

You know it access you have to scroll through each page. There's record selectors the bottom left of the screen

Thanks, have had the same issues myself.

id=9834567891011121 1st digit:left([id],1) = 9 2nd digit: mid([id],2,1)=8 3rd digit: mid([id],3,1)=3 and so on You need to understand what the mid function is doing. 4th digit: mid([id],4,1)= 4 since the 4th digit in your field is 4 - 9834567891011121 Does this make sense now?

Here's how I've solved the problem in the past. Create a table with the pictures. In your queries create the criteria that will select the proper record from the table of pictures. Once you have this you can bring in the picture to the report. Hope that makes sense.

step 1: If you are using design view in the query, click on the Group By button (Sigma). Group by driver, count of orders, min of order and max of order. step 2: query off the first and format like you want it. Here's a sample.

You can use the left, right, mid function to do this in a query. Then base the report off of your query. id=9834567891011121 1st digit:left([id],1) = 9 2nd digit: mid([id],2,1)=8 3rd digit: mid([id],3,1)=3 and so on also try out the right([id],1 and see how that works. You'll use these all...

I created an example but with only four date fields. Look at the data in the table then look at the report. Instead of changing the table fields, update date1, date2, date3, etc. Then put your date in date1date, date2date, etc. I put the dates as a report header so they aren't labels.

First I deleted your parameter value in your qry By Pay Period so it shows all pay periods. 2nd - create a query to get the current pay period since you didn't really define it. I took the max pay period of the qry By Pay Period and called the query qry Current Pay Period. 3rd - link the...

Make sure the sub report header is in the report header of the subreport. If it's in the page header of he subreport it won't show up in print preview.

I think this is the problem: WHERE (tblProductionTimes.ID= 51835 ) If you take out that criteria does it work?

You can query off of an existing query just like a table. Create a query that has sales by year. In that same query subtract 1 from your year. Then you can follow my example.

I'm sure an SQL statement could be written in one query. I've attached an example of how I solve this problem. Follow the queries in order and let me know if you have any questions.