Search results

I am having some issues trying to use both and & or in a If statement. The code below is what I am trying to do and it is not working. ElseIf (Len(Nz(Me.Associate_name, "")) = 0 And Me.Status <> "Expired") Or (Len(Nz(Me.Associate_name, "")) = 0 And Me.Status <> "No longer eligible") Then...

I have a form that contains order information with the salesperson id. At the bottom of the form I have a subform which displays all the records (orders) of the unique sales person based on the salesperson id that is entered on the record. Once the salesperson id is entered I am running an...

On my main form I have the Form On Current event set to Me.AllowAdditions = False to prevent new records from being added when users use the scroll button on the mouse. In order to add a new record users have to click on a command button. Here is the code when the command button is clicked...

I am trying to get the top 10 from a query and can not seem to get what I need. Table Name: New Field Names: GRP NAME (text) GRP ID (text) AMMS (text) COUNT OF AMMS (Number) I am trying to trying to display the Top 10 for each GRP NAME, GRP ID, AMMS based on the top 10 with the highest...

I am trying to get a count of Claim and Sum of Paid Amt where the Rend field is not equal to A6, A7, A8, DF, 26, 62, 77, 91, 93, 94, or 96. The issue I am having is when I run the query it is giving me count and sum from all the records. I am not sure what I have done incorrectly. Here is...

On my main form I have the Form On Current event set to Me.AllowAdditions = False to prevent new records from being added when users use the scroll button on the mouse. In order to add a new record users have to click on a command button. The database has been running smoothly for about a...

I have created a report and used the following formula and the report is returning a #Num! error. I have read it is returning the error since it is tring to divide by 0. How would I change the formula to get it to return a 0 instead of a #Num! error? =([SumOfTotal Points]/[SumOfTotal...

I have Access database in a multi-user environment over a 10/100Mb network. I am using a DLookup on the Employee ID field to return a employee's workload for a certain date and employee ID. I have noticed the database takes 3-10 minutes on this field for users not located at the same location...

I am trying to figure out how to have a form enter new records only. Currently, my form opens and pulls all the records from the table. I was wondering if it is possible to have the form open with blank fields and enter new records to the table and not display all the records from the table.

I am trying to generate a query and have noticed that the Memo field Comments is being truncated at 255 characters. I have searched and can not find a work around. I wanted to see if anyone else has run across this and knows of a possible workaround. Here is my SQL for the query...

I have a command button that users click to add a new record. I wanted to add some code that will check the field UniqueID and Date to ensure that the field is not blank. Here is what I have so far. Private Sub All_Load_Click() If [UniqueID] = "" Then MsgBox "Please enter Unique ID" ElseIf...

Editing SwitchboardID and ItemNumber I am trying to implement the following in order to password protect an area on my Switchboard. Here is a link to what I am trying to do... www.daniweb.com/code/snippet216570.html The problem is that when I follow the instructions on lines 85-141 I can...

I have a Form named Orders that has the fields OrderNumber, DateofOrder, and Price. I am trying to create a query that will give me the data for Monday through Friday if the user enters Friday's date when they run the query. I am not sure what I need to enter in the Query Criteria for...

I am still learning Access and need some help. My table has a field named Today and Number. I need the Today field to automatically enter the current date when the Number field is changed. I believe I need to use =Date() to accomplish this but not sure where to put it. Any help would be...

I have a Module titled Random that is suppose to randomly select 3000 records from a table. The problem I am running into is that as the Names table has higher number of records in it...there are more records selected. For example if there are 100,000 records in the Names table the code will...

I am not sure where to begin to make this work and any help would be greatly appreciated. I have a access table name Customers. The table has 4 fields customer number, name, address, and phone number. I have a letter in microsoft word titled Welcome Letter that I would like to be filled in...

I have created a MS Access Database and then found out that the users that need to enter and edit information in the database do not have MS Access installed on their computers due to licensing issues. I was going to use the Access runtime and change the database from MDB to MDE but I found out...

I have a excel spreadsheet with a header row and 8 columns Column A-C are set to text format Column D is set to Date format (3/14/2001) Column F is text format Column G & H are set to Date format (3/14/2001) When I try to import this into a new table it changes the date to a 5 digit number...

I have two tables (One table named Customer Info has address, phone #...etc and the other table named Customer Order has order info) I have joined the Customer # field from both tables and set it to include all records from 'Customer Info' and only those records from 'Customer Order' where...

I am looking for a way to force a shutdown on a database. I have reviewed the post http://www.access-programmers.co.uk/forums/showthread.php?t=103278 and follow this example with no luck. After following this step by step when I open the Shutdown.mdb (without holding down the Shift key) the...