Search results for query: *

I am creating a database to generate reports based on the current record in another database (table linked via odbc). I have linked the table where the current record would be pulling from, but how do I get the current record to show up in my report? Please help. liltechy

Here is the problem: AuthStDate is a date field. AuthEDate is a date field. I need to create in a query another field that will list out the individual dates between the two dates. For example: AuthStDate = 6/25/2003 and AuthEndDate = 9/30/2004, I need to see 6/26/03, 6/27/03 and so on. So...

Is it possible to do a autofilter with conditional formatting? I have a small spreadsheet that I need to print every month but I do not want to print the months with 0.00. Below is the data that I have tried to autofilter without success. MONTH Current Boardings YTD Boardings...

I am trying to automate a spreadsheet and need some assistance with a formula. Here is what the answer should look like for July: ALL ITEMS DUE BY 8:00AM ON THE 6TH WORKING DAY - AUGUST 9 This is my formula: ="ALL ITEMS DUE BY 8:00AM ON THE 6th DAY - "&UPPER(TEXT(WORKDAY(NOW(),-7),"mmmm d"))...

I have a financial workbook and need some assistance with a formula. sheet1 is where I enter my monthly totals. Sheet2 is the financial report. What I can't figure out is what formula do I use to have the current month's entry show up on Sheet2. Here is what sheet1 looks like: Acct# Descr...

In my shared database I have several reports where the underlying source is queries. The problem that I am having is that only one user at a time can view the report. If two users try to open the same report, one will get an error message that the report is locked. What do I need to do to unlock...

I have a combo box that on my main form that I want to refresh my subform, when I select my Vendor I get this error msg "Run-time error 3138- Syntax error in ORDER BY clause" and I don't understand why. Below is my code. Dim strSQL As String Dim strSQLSF As String strSQLSF = &quot...

I have a combo box with the following code and I get an error "You have canceled the previous operation" and I don't understand why. Can someone please help? 'I/O lookup Private Sub List20_AfterUpdate() ' Find the record that matches the control. Dim strSQLSF As String...

I inherited some Visio flowcharts and I need to reorder the pages but it will not allow me to do that. Why can't I reorder the pages? Any suggestions would be appreciated.

I have a main form that has two combo boxes and a subform. When I select the IO number in cbo1 it pulls all the records for that IO number in my subform. Based on the vendor numbers in the subform (pulled by the IO number)I then want cbo2 to look at the vendor number field in the subform and put...

I have a main form that has two combo boxes and a subform. When I select a IO number in cbo1 it pulls all the records for that IO number in my subform. I then want cbo2 to look at the vendor number field in the subform (after cbo1 has been selected) and put in the drop list only the vendor...

I have a Perdiem database that I am working with and I have a form with a main form with a subform. The main form contains these fields EmpNo, Name, Jobclass, PrimarySite. My subform contains these fields: EmpNo, Location (drop down), CostCenter, Date, Miles, NumberDays, Amount. What I am...

I am trying to create labels and I copied the code (from microsoft knowledge base) below into the controlsource of a textbox. This code concatenates fields to remove blank lines if a field is null. My fields are FIRSTNAME, SPOUSE, LASTNAME, ADDRESS, CITY, STATE, ZIP. It works fine but when I...

I need some help figuring out the autofill query. I have a main form with a subform. My main form is based on a table called tblEmploeeInfo. I want my subform to autofill the field Miles. The Miles should be filled in based on what data is in the PrimarySite field (main form) and the Location...

I have a user that created a table (does not want it change in any way) in a Training database. She created a form based on the training requests (tblTrainingReqs) and wants to create a combo box to find the trainers and their requests. I have created the combo box and each trainer is listed...

I am not sure of how to do this. Here we go, I have an inventory database the warehouse guy prints delivery tickets once he is through selecting the items, that works fine, but my problem is this; I was asked to create a form that would allow the warehouse guy to increase or decrease the...

Hour 1 Hour 2 Hour 3 Hour 4 What Hour 5,487 5,298 5,208 5,186 3,853 3,666 3,444 3,236 3,756 3,569 3,440 3,387 5,478 5,279 5,172 5,109 I have and excel 2000 spreadsheet, a sample is shown above. With the information above I need to get the max value and put the Hour in the What Hour column. I...

I am trying to count the occurrences of text in two different columns in Excel. The answer to the count should be on worksheet "RejectSummary" and the text occurrences is on worksheet "SWI". Below is the formula I entered but I keep getting 0. It should be 191...

I am in the process of creating a database where I will be printing invoices. There will be times when I will need to reprint an invoice with the original invoice number. Using autonumber will not allow me to do this. How can I accomplish this? liltechy

I am in the process of creating a database where I will be printing invoices. There will be times when I will need to reprint an invoice with the original invoice number. Using autonumber will not allow me to do this. How can I accomplish this? liltechy