Search results

I would like a field's default value to return the date of the previous Monday. For example: Now = Tuesday, 08-Apr-14 Return Monday, 07-Apr-14 Further example: Now = Saturday, 12-Apr-14 Return Monday, 07-Apr-14 Thanks for the help.

I have a A2007 database that is split to a shared server that is experiencing unidentified network problems. While working in the front-end users receive the following message periodically: If the users are working in a form including queried data, the data is lost and the file crashes. This...

I am using Access 2007 and I found that Access 2010 provides data bars as a conditional formatting option. I found the following code for applying data bars. I am attempting to apply the data bar against a control in a continuous report, but it is not working. The code does not error, but my...

I need assistance on applying conditional formatting to top 10 values on a control in a continuous report. Thanks.

I have two separate sub-reports in my report footer. The first sub-report must print before the second sub-report and there should be a page break between them. The problem is that on occasion the first sub-report may not have data. I have it set to visible = false if there is not data. This...

The following Delete Query is deleting all records, but I need it to delete only records returned by the subquery. The subquery correctly returns records when I test it without the Delete operation. Could I be implementing the Delete Query incorrectly? Thank you.

I am running VBA to append tables with spreadsheet data. When appended non-unique IDs, Access prompts "unable to append all the data to the table". The prompt asks if the user would like to proceed anyway - Yes or No. For my database, this prompt means an error occurred and the append...

"Enter Parameter Value" is prompted by DoCmd.OpenReport based on criteria from a combo box. The prompt box shows the criteria. Here is the VBA: The Me!cmbPkg value is showing in the prompt box, not the field of which that value is associated. So it's not prompting "fldPkg", but the data...

I need to join a table (qryDCFForecasts) to a subquery (z). The subquery includes all possible criteria combinations for the following two fields: "fldPkg", "fldDCF" Both (qryDCFForecasts) and the subquery (z) include both fields. qryDCFForecasts does not include all possible combinations of...

How can I group different types of data of the same field. A field includes several records with either Sarah, Julia, Amy, Bob, Joe. I want group this field based on "Girls" and "Boys", so that I can run a crosstab with only two fields instead of five. I hope this makes sense. Thank you.

In the below code I am receiving an "object variable or With block variable not set" error at this ErrHandling line: The code body works fine. Only the error handling is broken. Any suggestions? Thank you. Full Code:

I am attempting to add an audit field that rounds to the nearest month. Arguments for the Date() function appear to be non-existent. Excel Date() function requires three arguments - year, month, day. When I try to use these arguments in a field's Default Value expression builder, I receive...

My workplace has an existing Access 2000 database un-split on our shared drive. The file is secured via workgroup rights and a Secure.MDW. We have lost access to the file since upgrading to Office 2007. We have one computer that still runs Office 2003. While trying to take out the...

I have 4 tabs with a list box in each. Each list box executes the same query On Click. This query populates a SECONDARY list box. So 4 independent list boxes update 1 query that populates 1 list box. By opening the query after I click on each list box I can see that the code executes...

I initially had a form that included two list boxes. On Click event of the primary list box executed the query ("qrySecondLstBox"). qrySecondLstBox then populated the second list box. The primary list box after On Click simply read "Me.Requery". I then changed the primary list box to 4 list...

I would like to create a continuous form that is filtered on data related to a foreign key. The easiest way to explain my issue is to ask if there is a way to filter on a DLookup field. Thank you for the help.

I have multiple cases that includes multiple "true" results. I am confused about the best method to proceed with my query SQL. Should I use nested IIf's or does Jet SQL support cases? What is the correct syntax for multiple "true" results? There are three cases: Condition A, Condition B...

Bound combo boxes that I built in A2007 are not displaying on machines running A2003. I used the 2002-2003 file format though, which was the default new files. The bound values are being posted to the table. 7 of 9 combo boxes are not displaying values. The application has two separate...

I am using A2003. I have an single-Form that uses =nz(DMax(field),0)+1 for the key's default value. The key is set for no-duplicates. Multiple users are stumbling on each other when concurrently using the form. At this point, it's easier just to tell my small group to not enter the...

I have an A2007 report that includes 8 tickets per page. Each ticket represents a query record. I would like to show which "record of total records" a specific ticket represents, much like "=[Page] & " of " & [Pages]". The page function returns 1 of 3 when there are 24 tickets on 3 pages. I...