Search results

I am trying to pull data based on the greater of 2 dates. One being today minus a year, the other being the date entered in the [ReceiveDate] field. This is what I have in the criteria section for the other date field [Release_Date]. IIf((Now()-365)>[ReceiveDate],>Now()-365,>=[ReceiveDate])...

Hello, I have a combo box that displays all the files in a specific directory. Below is the On Load event for the form that makes the combo box work (found this by a search, thanks to whoever that was). After they choose the file they want to work with, I have a button to do the import of the...

Hello, I have searched the forum using various search criteria and can't find anything dealing with this. I also googled it and couldn't find an answer. I want to send query output in an excel format but I want the file to be password protected. It would be the same password each time the file...

Hello. I have a macro that runs a select query to pull back all group data from an outside database. The next step is a find unmatched query using the data pulled back from the select query against a table I want the data appended to. Next step, append the data retrieved with the find unmatched...

I have a database that is being used to house data for Mergefields in a Word doc, among other things. The document is in Word because it is about 16 pages long, but only needs the data for about 12 fields. However, the doc has 2 versions, one for the state of TX and one for everyone else. What...

I have a form opened from another form, filtered by a query with the criteria of a value in a field on the first form. If there is no data brought back by the query, the form opens with just the header label, no other fields. How can I have a message display that no data was returned instead...

Hello. I have a form, FrmPlanAdminStatus, that has a button to open another form, FrmPlanDoc. I searched the forum and found how to have 2 fields on FrmPlanDoc prefill based on the record displayed on FrmPlanAdminStatus. I am setting the default value on the FrmPlanDoc to the field on...

I have been looking through the search results using various phrases to try to find what I need. I probably have found it but just don't know how to apply it. I have a Date_Created field to pull back payment information. There is another field, SignDate, on another table. I need to pull back any...

Hi. I searched the forum and found a couple of posts regarding this, however, the situation wasn't quite the same. I have a query that pulls back 2 separate totals , InternalRemits and ExternalRemits. On the report, I want a TotalRemits column. This is what I have ...

Hello. I have done this umpteen million times, but for some reason, this one isn't working. I have a query that is summing amounts by [Carrier]. There can be as many as 50 carriers per [Group]. So I am displaying the list of carriers and amounts on a continuous form, frmVendorList, per group...

I have 2 related tables. The form to enter new data into the tables is set up with a subform for the second table. I want to allow the user to query for a specific record, have it display in a form that looks exactly like the data entry form, and be able to update the tables from that. I first...

Hello. I have a query that is pulling data based on a date in a table. For some records, that date field is empty. For those records, the data should be pulled based on the date of 1/1/06. I tried doing this =IIf([Signed SLA Received] Is Null,1/1/06,>=[Signed SLA Received]) It doesn't like...

I have a report based on a query. The query criteria of Between [Start Date] and [End Date] in the DateReceived field. I had this report built in Access 2000. In an unbound text box on the report I had : =[Start Date] &" to" & [End Date]. It worked fine when it was in Access 2000 but since we...

Hello, I have a form and subform linked by the ID field (AutoNumber) on the Form and Record ID field (Number) on the subform. I have the field size on the Record ID field set to Long Integer. When the form is opened, a message pops up "The LinkMasterFields property setting has produced this...

I am trying to link a table from an admin system in Access. I'm not real confident that I will be using the correct terms here, so please bear with me. We recently migrated our admin system from Unix to NT. When we did that, the ODBC driver that we used to use to link to a table through Access...

I have a file that was provided on CD that is over 2 million records. I have successfully imported it into Access 97. Now I am building queries against it. There are a few different queries where I need to have a date range as the criteria. My problem lies in the way the date fields exist. There...

Hello all. I searched the general forum and found a couple of things relating to the internet, but nothing that answered my question, so here goes.... Is there a way to put a form on the internet to collect data in a table, without anybody being able to see the data that has been input so far...

Hello all. This probably cannot be done, but I'm going to ask anyway. Here is the scenerio: I have two make table queries that both have a date prompt, >=[Enter Start Date] And <DateAdd("d",1,[Enter End Date]). These queries bring back alot of data. I have a crosstab query built against each...

Hello, I have a crosstab query built on another query. One of the fields is named [Doc]. I have that field set to Group By, as a column heading. There are two values possible, Pass and Fail. I need both Values to appear as fields on a report. My problem is, currently, there are no entries for...

I have a query built on two crosstab queries. The linked field is Processor. The data in the first crosstab query contains 3 processors that are different than in the second crosstab query. The second contains processors that aren't in the first. What my ultimate objective is is to have a report...