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.

Thank you for your explanation. This confirmed my plans to split to SQL Server.

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...

I tried the error handler both ways. The problem - I believe - is that existence of a duplicated ID is not picked up as an error, rather Access' canned handler (prompt) executes. I want to do away with the canned handler. The "operation cancelled by user" occurs only after the MS Access prompt...

This issue has not been resolved. I still would like to override Access' prompt with my own procedure when duplicated IDs are being appended.

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.

Thank you Gemma. I used: The "unable to append" prompt is still occurring. Err.Description within my message box simply says "Operation cancelled by user", as if the user caused the error by choosing "No" and interrupting the operation. My main priority is to remove the possibility of the...

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 was able to use two sets of criteria with in the JOIN statement. For some reason I didn't think the obvious would have worked. All works fine and Null values are being returned.

Thank you for the suggestions. qryDCFForecast Null records are still being filtered out on your suggestion and different flavors of the following IIF statement. All attempts have returned the same records. Btw, qryDCFForecasts.fldDCF is the problem field that causes Null criteria. SELECT...

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...

Thank you Plog. Even though you referenced a helpful database principle, I used gender as only an example, albeit not a perfect example, because categories for my actual "gender" data is easily defined. This is why I'm surprised there is not an easier way to group categories thru SQL.

Thank you for the help. If such a concept is possible, I expected that I would need to apply some kind of alias. I suppose I will need to add a table that identifies first names with boys or girls and then join the field with my working table. I just wondered if SQL could help. Thanks.

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.

That worked. I declared my database only once and set the object twice. Thank you!

Quick note: DoCmd.TransferSpreadsheet should be followed by acImport. I made some global changes before posting the code in the thread. I apologize for not scrubbing the published code. Back to business: The code executes as planned when I comment out the error handler. And it executes fine...