Search results

I have tried nz() the result was always green

I have created a form to cross refrence part numbers among suppliers. When the manager selects the part they normally order it will show below 7 possible alternate suppliers of an alternate part. I need the text of the lowest price supplier's part to be red. The subform containing the pricing...

I have a named range in an Excel Spreadsheet called "ImportArea". Is there a way to import a named range in Access (2000). I can do each individually but I get errors when trying to get it all at once. ='Fee Matrix'!$A$5:$C$5,'Fee Matrix'!$A$8:$F$27,'Fee Matrix'!$A$31:$F$59,'Fee...

I have a query that is working exactly the way I want it to in Access 2000. Each record has 1-8 possible descriptions and so I used a subdatasheet to list them. My trouble comes when I try to export this to Excel. The subdatasheet information is lost. Is there any way to get this out to...

Was that yes that multiple users will be able to access the db at the same time? The drive is mapped by the main office and consistent. The links will be on the same drive. The data is entered into a table and then appended on close to another. If two people try and enter data at the same...

I have an Access database created in Access 2003 but left in Access 2000 format. It needs to be shared via a Citrix portal, MSAM, with 14 offices accross the US. The users will be entering numbers in a form and will have buttons to run reports. What is the best way to deploy the application...

The data is stored in a propriatary system called Knowledge Base. I don't know much about the system and this is just a short contract to automate one report. I have a work-around which includes gathering the Historical data and then going forward the customer will only need to append current...

I did do this but with only 2 out of 12 months it took a huge amount of time (>30 min). I'm afraid if I add the other 10 months it will have to run over-night.

I corrected & to + and the error I get is: [Knowledge Based Systems, Inc.][server API][v4.3]SQLPrepare: Invalid Syntax: expecting FOR READ ONLY or FOR UPDATE (#39) SELECT PATIENT_ACTG.J_ACCOUNT_MSTR.fSCL_YR + '01' AS AcctPeriod, PATIENT_ACTG.J_ACCOUNT_MSTR.GL_DPT...

I need to rearrange a table that has values stored in 12 fields, one for each month. Below is the union query that I wrote, it does give me what I'm looking for but errors if I make it a pass-thru. Running as a non-pass-thru takes FOREVER! I need to be able to perform the concatenation on the...

What I've ended up doing is a Union query which will provide data that can be manipulated. I tried running it as a passthru but got errors on the concatenated first field. SELECT PATIENT_ACTG_J_ACCOUNT_MSTR.fSCL_YR & "01" AS AcctPeriod, PATIENT_ACTG_J_ACCOUNT_MSTR.GL_DPT...

I have a SQL table that holds financial data. There are 12 columns labled Acct_Per01 through Acct_Per12. I need to select specific GL codes and sum the values in these columns as various groupings, Private, Commercial, Ancillary etc. for each of 14 hospitals. How can I best create a working...

It was working fine with the me.hospital= "" then statement when I put it in yesterday. I was confused when it ignored the null today. Thank you, the IsNull([Hospital]) Or [Hospital] = "" Then is working correctly.

The code below worked fine yesterday, today the form just opens either way. Any idea what could change overnight? Private Sub cmdEnterData_Click() 'If Me!Hospital = Null Then 'I tried this too. If Me.Hospital = "" Then Beep MsgBox "Select Hospital Abbreviation", vbOKOnly...

In my table tAdministrators the field LastResponse will contain a date. If that date is more than 25 days in the past then they need to have a reminder sent. I want the code to pull the email address from the email field in the table and send the reminder. DoCmd.SendObject acTable...

I have a table with email addresses and want to write code to send automatic reminders using these addresses. The group is required to submit information on a monthly basis and when it is late I need to send a reminder. The table will contain an indicator whether the person has submitted...