Search results for query: *

OEM USR 56k voice/PCI fax card is very slow sending & receiving. works fine with data. If I query the modem after after a data call (ati6)it indicates the last connection at something like 42000/28800 but after a fax call (send or receive) it indicates 300. Using Microsoft Fax Monitor under...

I copied and pasted the whole thing...I think its what you wanted. The 2nd line of type (Private Sub Combo 56...ect) is highlighted in yellow with a yellow arrow pointing toward it from the left. Just beneath this, ".DefaultValue =" is highlighted in blue. Option Compare Database...

Also, the field I am working with uses a combo box, just incase this makes any difference. Thanks again, Matt

I inserted the brackets around the field....thanks. However, when I use this form, it returns to Microsoft Visual Basic, highlights ".defaultvalue =", and says "Compile Error: Method or Data Member Not Found". Sorry for all the questions, but I've only had a 2 month Access...

RickSpr & Gol4- Thanks for all the help! Entering the code using "event procedure" works great. However, when I attempt to enter a fieldname of two words, for example: "Intersection Name", there is an error in my code. Any thoughts? Thanks, Matt

I entered this information in the "after update event" and then attempted to enter data. However, Access then says that it cannot find the macro "me." I am fairly new to Access and am not sure what steps need to be taken to correct this. I assume that a macro must be...

How do I setup a form to default to the most recently entered data? For example, in Field1 I enter "A", and in Field2 I enter "B". When I click the new entry button, I want "A" and "B" to appear as defaults for their respective fields. I would like to...

Gol4- I used your second post, and recieved an "invalid syntax" error when I copy and pasted either into the form. Any ideas on what might be wrong? Thanks, Matt

I'm trying to set a default in a form for the name of the previous month. For example, on June 10, 2003, the default would read "May". If its not possible to set an entire name as a default, I could also use numbers, ie. "5" for "May" Thanks, Matt

How do I set the default in a form to the previous month? This question probably has a very easy and obvious answer, but I'm new to access and couldnt find it in Microsoft's help files. Thanks, Matt

Thank you VERY much. Your post solved all of my problems that I had spent days on in 10 minutes. It works great and was very helpful. Thanks for your time. Matt

No, the month number is not the same in each row. I am trying to list "Codes" according to month. Currently, I only have data for April and only 2 of 3 "codes". Therefore, in Q1, 53 records exist. 42 of these are data for April, and 11 are for the remaining months with...

Here is the current SQL for Query 3: SELECT [1].[Month Number], [1].[Month Name], [2].[CountOfProblem Code], [2].[Problem Description] FROM 2 RIGHT JOIN 1 ON [2].Month = [1].[Month Number]; Thanks for the help, Matt

I have three tables: A, B, and C. Tables A and C are each outer linked to table B. I also have two queries. Query 1 is based on table A. Query 2 is based on table C. I now wish to make an additional query (query 3) that combines queries 1 and 2. However, when I attempt this, the number of...

I have tried each type of join and where, & and I'm still having problems.

I have a table called "Maintenance Summary" that contains 1468 rows of data. I also have a table called "Months", which has no relationship to any other table or query, and contains 12 rows of data (numbers for corresponding months). I query various fields in the...

In a query, I have entered "Month: Month([NameofDateField])". This works to group a count by month instead of individual days. However, the query does not list months that have no corresponding data. How do I make the query include every month of the year, even if some do not have...

In a query, I have entered "Month: Month([NameofDateField])". This works to group a count by month instead of individual days. However, the query does not list months that have no corresponding data. How do I make the query include every month of the year, even if some do not have...

I'm trying to use an Nz function within a count. I realize that this is probably a simple question, but where do I insert the Nz function? I think I understand how to use the function, just not where to use it. Thanks for the help, Matt

I have specific dates (including day, month, and year) in a table with corresponding data. In a query, I wish to count this data for each month. For example, I want to have an individual count for each month Jan. through Dec.. How do I tell a query to separate these months and count according...