Search results

Hello, I have run into a snag with my reporting. I have a complicated report that I can't seem to get to work the way I would like. I have a Daily Progress by Standard Action report that is made out of several subreports using the query qlkpStandardActionPoints query to pull data for each...

Hi guys, I have three radio buttons (Screen, Print, PDF) that I am using to view, print, and save my reports. I am using nested if statements that look like this. If Me.txtReportName = "Week at a Glance" Then If Me.rdbScreen.Value = True Then DoCmd.OpenReport "rptWeekAtAGlance"...

Hi guys, I'm a little rusty on the syntax for multiple criteria. I need the number of records that have the Plan ID of "Me.txtWeeklyPlanID" with the ActionIncluded = True and the ActionIDFK = 3 This is the code I use, but I get an "Expected list separator" error. DCount("[ActionIDFK]"...

Hello everyone, I am hoping you might be of some help. I want to copy the records from the previous week into the same table, but with a different weekly Id. In my code I assigned the previous week to the "prevPlanID" and the current week to the "curWeeklyPlanID". Here is the SQL I used, but...

Hi Guys, I added a new field "birthdate" to an existing table and form. When I go to add a new record using the form, the birthdate field fills in with "#Name?". I am stumped! Does anyone have any idea why this may be happening?

I have a report and if the detailed section fills the page, I want to put what's in the footer on a separate page. Is that possible?

Hello, I'm trying something that is a bit difficult but will be worth it if it works. I need to copy records from the table "tblMealcomponentsPerWeeklyPlan" with the "WeeklyPlanIDFK"=Tempvars!TempPlanID and the "DOW"=1. When inserting the records I need to add a day to the date "Date...

Can anyone see what I'm doing wrong with this one? DCount("[WeeklyPlanID]", "tblWeeklyPlans", "[UserIDFK] = " & lngUserID & " AND [StatusFK] <> " & 'New') I tried the New in double-quotes too.

I have a couple of crosstab queries for days of the week. My problem is that if, say week 2, has no data. The report doesn't recognize the field and the report doesn't print. I am making the crosstab query off another query that gets all the records that have a type of "personal" and where...

Hi, I have a report with 3 subforms all need to be filtered by the value on a field in the main report. I tried to filter the queries, but it keeps saying it doesn't recognize the forms value or temp var value. I'm lost, any suggestions?

Hi, I could use some advice on this one. I have to copy all the data from one form for a certain Meal Plan and put it back into the same table with a different Plan ID. I was trying to use an append query, but am having some trouble. I have the plan id saved into a temp var called...

Can someone tell me what's wrong with this? These are so confusing. I never know when to put the quotes and when not to. DLookup("[WeeklyPlanID]", "tblWeeklyPlans", "[UserID] = " & Me.txtUserID & " AND [Loop] = '" & loopNum & "' AND [WeekNumber] = '" & weekNum & "'") I'm getting a data type...

I have a form that adds a measurement to the measurement table ie: cup, oz. When I close the form I am trying to requery the combo box on another form. Here's what doesn't work. [Forms]![frmMealComponents].Controls![cboMeasure].Requery I also wanted to query the subform and it's not letting...

Hello, could someone tell me what I did wrong here. These statements are a bit tricky with the syntax. It was working once and I forgot to save it and now I can't get it to work again. I'm probably just overlooking something simple. Here is the code...

I am filtering a form based on the value of a textbox and when I click the next button it queries the main form and I'm trying to query the list box as well, but it is not working. There is no control source on the box, but there is a row source. Any suggestions. I tried to just query the...

I have a checkbox that is not checked and I am checking the value of it in the code with an if statement. I keep getting this error "You entered an expression that has no value." I am stumped. I have used this format before and it works, but for some reason, it is not working now. Here is the...

Hi, I have a time field that I pulled in from a table. when I run the query it gives me 2 extra zeros. ie: 7:00:00 AM Not sure how to fix this. The fields name is StartTime and I tried StartTime:Format([StartTime], "hh:mm AM/PM") with no success. Any help would be appreciated.

Hello, I can't seem to get this right. I have searched online and nothing seems to work. I have a main form with two subforms. One of the subforms is a list that when I hit a button I can add new records to it with a nice data entry form that pops up. You can still see the original list and...

Hi, I have a form that has several subforms on it and when I open it in a modal view, the vertical scroll bar disappears. It is there if I take it out of modal, but I really want to be able to use the modal feature. I hoping to have the program act as an app that the user doesn't see any of the...

Hello, I am having trouble getting a date formatted correctly. I just want the mm/dd to show in parenthesis. ie: (3/9) It was working when I created the text boxes, but when I went to display the forms it didn't work. In the control source, I am using a temp variable "TmpStartDate" and...