Search results for query: *

We're replacing an old AS 400 database with a new SQL database. I've recreated the view in the SQL database but now I have an Excel spreadsheet referencing the AS 400 via DSN connection through a macro. Here is the current connection string: With...

I'm building a database for document distribution. Right now I have a many to many relationship between Document and Revision. Document DocumentID (PK) DocumentTitle DocumentRevision DocumentID (FK) RevisionID (FK) Revision RevisionID (PK) Revision I also need to associate each...

I have a database that worked fine in Access 2003. Now that I'm using Access 2007, it gives a run-time 3027 error. It is breaking down on the DoCmd.TransferText line. I've tried this on multiple computers (XP, Win7) and the file is being saved to the C: drive and I have administrative...

I'm fairly new to Access 2007 having recently upgraded from 2003. I have a form and have added buttons to it but they don't show up when I view the form. I tried stacking and ungrouping the buttons but the new buttons still don't appear and their .visible property is set to true.

I have a query with a True/False field and a form with an option group with options 1=Both, 2=True, 3=False. I tried using a nested IIf but am not sure how to code the Both option to select all records. In other words, if option 1 is clicked then select ALL records. If option 2 is clicked...

I have built a many-to-many relationship via two one-to-many relationships. Table: tblDR Pkey: DRNum Table: tblDRPerson Fkey: DRNum Fkey: GroupID Table: tblGroup Pkey: GroupID Field: GroupName I have a form called formDR with a subform called “Groups subform”. I can select a group via the...

I have a query called queryCauseCodes04 with this result: CUSRE EXGM FTDD FTFM FTFSP 0 3 1 4 2 I need to convert (Update?) it to a table called CauseCodes: CauseCode Count CUSRE 0 EXGM 3 FTDD 1 FTFM 4 FTFSP 2 There are 18...

Has anybody successfully recreated the WIP Report in either Crystal or MS Access via ODBC? Unfortunately, the canned report is a Progress report. I've been working through the help file but I get lost between pages 6-8. We don't even need it as complex as the WIP in Vantage, where labor...

I'm trying to define a variable based on the value of a cell. The column is static but the row is ActiveCell.Row. I can't find how to reference it. Something like: MyVariable = (B,ActiveCell.Row) ...where B is the column and ActiveCell.Row is the row I need. The example above doesn't work...

(Access 2003) There's lots of information on how to use a multi select list box's selection to filter something. I'm thinking of a backwards approach. Is it possible to use a query to set the selections in a multi select list box? I would like to do this to allow a user to see the "default"...

I have a form with a checkbox and am using a button with the following code: strSQL = "INSERT INTO tempEmployees ([Completed]) Values('" & Me.cbxCompleted.Value & "')" The problem is, when I type out Me.cbxCompleted.Value ... .Value is not an attribute of the list. So how can I capture the...

I'm using Crystal XI R2. Here's a sample of my data set (grouped as you would see it in a report): Quote Line QtyNo Qty UnitPrice QtyTotal 1500 1 1 1 5000 5000 2 50 4500 225000 2...

I put a multiselect listbox on a form. It works great, I can select members of the list. I'm trying to learn how to code a button to append the selected items to a table. For example: I have a table called People with fields ID, FirstName, and LastName. This is my multiselect listbox. I...

Hello, I've implemented code to open a query as a recordset and am looping through the recordset to send and email for each record. The code works fine but I can't manage to get the email body fields to show up on separate lines. I've tried both Chr$(13) and the vbcrlf. When I have the...

I'm doing the transfertext method, which works great. What I want to do is strip out the commas. I have created an export specification and can view the comma in the FieldSeperator field but cannot change it (or delete). Any ideas? I've read that you can do it through SQL append but don't...

I have a table with a field called RptPeriod. I have a form with a textbox (Date_txt). The user enters a value (text format, ex. 2005.MAY) and clicks a button to update all records within the table. I tried creating an update query and in the Update To box entering the following...

I've exported and manipulated data from another system into a table with 3 fields, GLDEPT, CHART, and YTD. I need to add more fields (with recurring default values) to each record so that I can export the table into a text file. How can I add the fields (through code)? Right now it looks...

I have a global variable defined on a form and would like to have a text box on my report = the global variable. I tried inserting the text box and setting it equal to the variable but Access converts this to a field with [] around it and does not work. How can I call reference the variable?

I'm using FancyPrarie's BuildWhere module to generate a dynamic report from a single form. Everything works fine if I use Text Boxes. I have the following fields: txtLaborDate_BeginR Tag = Where=LaborMain.ClockInDat,Date; txtLaborDate_EndR Tag = txtGroup Tag =...

I have a table called Labor with the following fields: Date Project Dept Hours Rate I need a flexible report selection form to allow different department managers to select specifics to print a report. I could manually build some 60 reports and make them all happy but I know there is a way to...