Hi, I have this code: 'This will check to see if the job has been released by List Maint. to production, if not then then job cannot be processed ...

Here's what I have in a query thus far. D: Sum(IIf(!="D" Or !="D", !+!,0)) The problem is I don't want to use OR nor does AND apply. I want the DP Value...

strwhere = strwhere & "## Between " & "#" & Me.BegDate & "#" & " And " & "#" & Me.EndDate & "#" I'm trying to read a date field in a query from a combo box...

I have a form listing all details and when I press the button I want a record inserting into table containg the & Competency_ID however I'm getting a...

I use the following query, as the row source for a chart on an Access Report. The Query definition is modified on the report Open event to modify the date...

Access 2003, Win XP Pro... I am using a subform that contains a memo field in a form. the property for the field in the subform is "can grow" "yes". It doesn't...

I copied the 3rd combo statement to be exactly as the second, except to change field names, but the query wont even open.... dim strWhere As String If...

Does anybody know of an Access 2003 or Excel format that can help us track our print and radio advertising contact people, plans and expenses?

I have textbox on a report (Detail Section) that uses the DSum domain function. I am trying to add an amount from a table with a criteria value from a Form....

I have two fields. One is a combo box name "salesman" the other is a text field called "office" I want the "office" field to autofill in the text needed when...

Hi, I have this code and for some reason I can't get the value of the field. What am I doing wrong? !!! Thanks in advance! Anna

I have a table called radial miles with 600 town names in the field and 35 quarries as column headings. All the radial mileages are filled out in the...

hi, i have a dataentry access form which is also used to show data. it have some unbound textboxes as well which shows calculated fields based on data in...

How can I export a bunch of pivotcharts to .pdf? Any help would be greatly appreciated. John

I do have a problem with an Access application i dont have developed myself. I have a form with several unbound subforms. The datasources in the subforms is...

Ok. For one more time I need your help. I have a form and a subform in it. On after update event on both (form and subform) I added the simplest thing I could...

Please can someone help. I have a form built that was working fine last week, but with no changes made it now doesnt work for some users and does for others....

Form:Form(1) View: Datasheet Record Source: Query(1) Table Source: Multiple tables Problem: Entering data into any control in a New Record causes the "Field...

I created a droplist on my form. I linked it to to a field in my table called AdHocACCCode and named the droplist AdHocACCCodeBox. The droplist gets its...

j