Search results for query: *

Hello All, I'm new to Mysql and am having some trouble. I'm trying to insert into a junction table, "action_x_recipient", and I'm getting a 2013 error code. When I run the query w/o the insert, it runs fine. Basically we get a big data dump (over 8 million rows) which I need to move into...

Greetings, Feeling a bit dim-witted here...I'm working on a label report in Crystal 9 which needs to print a barcode on the bottom of each label regardless of how long the name and accompanying info is (which needs to be positioned at the top of the label and grow downward). Like this...

I am running Crystal 9.2.0.448 against an 2003 Access DB and am pulling fields from two tables. The problem is that one of the fields (contacts.bounced?), which was removed from the report and also from the DB is now appearing as a parameter. When I open the Field Explorer to see if the field...

Hello, I have a multi-user Access 2003 database with front and back end security that has been working just fine for everyone. One power user was recently upgraded to Office 2007, and there have been issues ever since. I believe everyone else is still running 2003. This latest one happens...

I'm using Microsoft Access 2003 and running a report off of it in Crystal. The report is pulling data from a query, which in turn is getting it's data from both internal and linked tables. There are four "tables" in the query, the first is a query that is based on internal tables. The...

Hello all, my problem is quite similar to one- yet unanswered- post from another fellow titled "Business View Problem." However, I'm sporting Crystal 9.2.0.448 and running it against a Microsoft Access 2003 DB. (The Access DB is in turn linked to another SQL DB). I have the report looking at...

I’m trying to create an update query where a table (tblCE_Contacts_NF) is updated based on a different query (test1). I’m new to update queries (and new to Access for that matter) and am having trouble with the coding. I’m running Microsoft Access 2003. Any help is greatly appreciated! The...

The Workshop Tree (the left hand column with a listing of all the formula fields) has disappeared from my Formula Workshop window, and I can't find it. The rest of the Workshop Tree is fine, but moving from one formula to another is problematic. Does anyone know how to bring it back? Thanks!

Good Afternoon, I'm looking at a "broken" report that only sometimes runs, and when it does it returns blank. Otherwise I get a row error. The report appears to be calling a stored procedure, but we're not quite sure. When looking in the Database Expert, the stored procedure appears as a...

Hello All, I have a report with a pie graph where you can see the legend. There are quite a few slices in the pie, so when I printed with the automatic colors assigned by Crystal, you couldn't discern the color differentiation. So I slightly changed the colors and added patterns to make it...

I have a (split) database created in Access 2003 on a shared network. Users with Vista (they're running Access 2007) are able to open the database and the forms, but event procedures (OnClick) don't run. I can open the event procedures and see them there, looking all ready to go, but Vista...

Good morning, And please pardon my lack of Access vocabulary. I’m just learning… I have a table [tblProducts] that has a many-to-many relationship with itself. It connects via a junction table [tblProductsProducts] by the Product_ID field [and Product_1_Id]. Basically, there are products...

Hello! New to Access and having a time. Basically I want to be able to add records to a subform based on a non-id combo list. Did some research and it appears that this can be done with an unbound combo- great! But sadly, it's not working. So, here's the background (probably too much info…)...

I'm wanting to select incoming data by comparing a multi value parameter to a text field(2000)which holds more info than that entered in the parameter. An end user should be able to choose multiple codes (i.e. A, G, L, Z) as a parameter field (text) and the report should check each of those...