Search results

Hello, I'm trying to create a report that has several sub-reports. There are a few line graphs I need to include, but I am having problems creating one. Besides charts being nearly impossible to create in Access, any time I save the report and close out, it is missing. I cannot see it in the...

Not sure why the above wasn't working. But I added in a line to requery the main form first and that worked. My new code is: 'Requery contract Forms!frmContractForm.Requery 'Find contract With Forms!frmContractForm.frmContractSub .Form.ContractID.Enabled = True .SetFocus...

Hello, I'm trying to find a subform record from a separate pop-up form based on its ContractID. When I click the button, I get the following error: "A macro set to one of the current field's properties failed because of an error in a FindRecord action argument." When I step through the code...

Hi, I'm having trouble with the Keep Together option in a report. I have a two groups, one is an expression: 1=1 (with Keep Together and Repeat Section in place of a page header), and the other is by ID. The details are notes associated with each ID. I would like to keep the detail together...

Right. I don't want the actual phrase changed, just the font of the phrase.

Users open a form, looking for any contract with the phrase "tax code." A report comes up, listing all contracts with "tax code," in the field [Language], and highlights that phrase. So one contract's Language field might say "Tax code has been updated in 2014." Another contract's Language...

Thanks for the quick response. Since I'm highlighting parts of strings (and not the whole textbox), the first letter is not necessarily going to be capitalized. I'm not sure this code will work for what I want to do.

Hello, I'm trying to open a report and highlight certain text. So I have a textbox that takes the original field and replaces certain text (based on user input) in bold red. Here is my formula: =Replace([Language],[txtKeyword],"<font color = ""red""><b>" & Upper([txtKeyword]) & "</b></font>")...

It is not open to manipulation, as it is a DE file. The DB file that houses the tabes is in the same folder, but password protected. The DB file that I use to make changes to the objects is in my personal folder. I just use that and save over the DE file when I'm ready for my changes to go...

Gemma, Thanks for the quick reply. Because it's still importing properly (just with error messages), there's no import errors table. For this same reason, I'm not sure the text/numeric fields would be the problem. The users that are having problems are still running Windows XP, while my...

Hello, I am getting really frustrated with a common error in VBA imports. It has happened with spreadsheets and text files I have users importing. An error message pops up "Type Mismatch." But the import appears to work correctly. So I added code that On Error, if error Like "*Type...

Hello, I'm using VBA to create a query, then export that query, using TransferSpreadsheet, to Excel. Sometimes it works, but sometimes I get an error that the "Object or database is read-only." The file is NOT read-only, and it's also not open when I do it. I even have a command that if it's...

The thing is, it's no field specifically. There are no error tables that produce from it. And it works just fine for me.

Hello, I created some VBA imports from a saved Excel file. When I run it on my computer, it works fine. When my coworkers run it, they get an error "Type mismatch." Some files seem to upload despite the error, but I'd like to figure out why it's happening, especially for cases where the data...

Hello, recently I split my database to protect the data. I created one database that houses the tables, which is password protected. The other database houses all the objects, and I created an ACCDE for the other users. Since I did this, the other users are not able to do things such as use...

There are actually other formats in which I can obtain the data, so instead of CSV, I chose Text File Delimiter, using "|" (pipe) as a delimiter, and quotes as a text qualifier. After having to change/add field names for duplicate and blank field names, I was able to set up an import as a text...

@jdraw: I did not get an Import_Errors table, it just did not import at all. I don't think any field has criteria. They are all text, some have a format of "@." I would assume that wouldn't make a difference. I wish there weren't so many fields, but I have no control over the data source...

Help! I'm trying to set up a saved import, but keep getting the following error message: "You cannot record your changes because a value entered violates the settings defined for this table or list (for example, a value is less than the minimum or greater than the maximum). Correct the error...

Thank you both very much for your help! In my case, the front end database is stored on a shared drive, rather than each person's desktop. If each user saved it to his desktop, would the data still save to the back end database on the shared drive? Also, I make frequent changes to the...

It does, thank you. But it still leaves me with some questions. I don't know exactly how to go about these steps. How do I "put the tables in the back end?" When I create the ACCDE, they are already there. Do I split the database, link everything, then make the ACCDE? Re disabling the...