Search results for query: *

I have a query that I'm using the criteria to pull from a form. If the form = "All Medical" then I need it to use 2 of the value list for criteria. Here is what I have. It gives me the expression is too complex error. IIf([Forms]![frmQA_Report_Interface]![Producttype]="All Medical","HCFA"...

Anyone know where I can download the old DOS Installation? I have some old GP DOS Data that I need to get into... Don't think and the solution will come.

I have datasheet form that has a datasheet subform. When I click the "+" on the subform to view the record I want to see the current record remains on the first record. Sorry if this sounds confusing. Here is an example. If you select the + on the 3 record the ">" cureent record remains on...

I have an access 2000 database used for reporting claim production and inventory. On my main report, which is a report with about 7 subreports on it, I can run the report for a weeks range and the report in print preview and printed are the same. I run the same report for a months period and...

I am trying to an onclick event that would give the message below if there are no records. The error message is Runtime 2427 You entered an expression that has no value. Which is true and thats what I'm trying to do with the message box so they know to generate a Submission prior to editing...

For the Pas 2 weeks since I changed my password my network account has been getting unexpectedly locked. Something on my pc ( I assume ) is trying to log into our server sending the old password. I have checked all of the programs for a login and password where it might have asked on install...

Ok I am using a button on a form to exit the form. I have validation in place and would like to ask the user if they want to save the record before exiting. Here is what I have so far. The Validation works but it skips past the message box code. I am new to this so you may be able to get the...

I am trying to validate some fields based on other fields in a form. I have two fields that if they are > o then at least one of three other fields needs to have data. This is where I am now. The three fields are date fields and I am using access 2003 and access 2000 as my default. Private...

I am trying to validate some fields based on other fields. I have two fields that if they are > o then at least one of three other fields needs to have data. This is where I am now. The three fields are date fields and I am using access 2003 and access 2000 as my default. Private Sub...

I am trying to use an if statment on in my module where if a table has a field with a value of 1 then do the statement if else continue. This is the code I have so far. Can someone point me in the right direction as to how to get this working. Everything works but the if. I have other code...

I have SQL 2005 as a back end database and Access 2003 using 2000 default as the front end on the same machine. I am connecting with ODBC between the two. I have link tables in Access to the SQL 2005 and if I do a delete query I get the message "Could not Delete from Table". I figured it was...

I have a table where I need an autonumber to start at 30000. With this in mind I will be using a DELETE test.* FROM test; and Reloading this table with new data. How can I get the Autonumber to restart at 30000?? Thanks, Stan

I need to return all rows in the table clmdes1 except for row 167063 and 167064. How can this be done?

Ok, I need to use a table of email address's to not be included on a query sort of like [Bad_Email].[Bad_Email]<>[ConsentMaster].[member_email_address] Below is the query I need to have this work with. I have tried every variation possible. Any help or tips will be greatly appreciated...

I have linked tables to a server that gives me dates for example 20060216 as a number field. How can I change this to a date/time field? Any Sugestions?

I want to block just one page that sits in the root of my site. This page has a link to a word document which is really what I am trying to block. Which method, meta tag on the page that has the link to the word document or a robots.txt file like: User-agent: * Disallow: /download.htm Which...

Does anyone know how I can get a copy of v6.15 btrieve microkernel database engine?

My company has an old DOS Great Plains system that apparently is on one of our old servers. This was before my time at the company so I know nothing about it. I need to get it up and going to access some data in it. On the server there is a GPS.bat that apparently should start the app...

Can a Report have multiple detail sections from the same query?

Using Access 2000 I currently have a command button on a form that has the following code DoCmd.RunCommand acCmdImport Then I have another command button that renames the imported table to a table I use in various queries. DoCmd.Rename "TEXN TOP TEN DATA", acTable, Text24 The Text24 is a box...