Search results

In your query in the criteria under the date field type in: > [Enter Date Value] That will give all the records where that date is greater than the date entered. You may want to add "Enter Date Value" with a date/time datatype to the query parameters by right clincking in the upper pane and...

This code will create a duplicate record for each record in your table. You will need to change it around a bit and put in your field names. Not sure if the date value will be the same for each of the new records or not, but this should give you a place to start. Good Luck! GumbyD Public...

Thank you for the e-mail. Glad that your database is happy now! GumbyD

Create a grouping query and bring in the ID field twice. In the first column "GroupBy" the ID field, In the second Column "Count" the ID field. In the criteria under the Counted ID's put >1 that will show you all the ID that are in more than once. GumbyD

In the report footer add a textbox. In the textbox type =sum([royality]). That should work as long as the royality field is a numeric value. GumbyD

Try NewField: CCur(0) GumbyD

Ashley - You are having Refential Integrity issues. The error you are getting is coming up because of the way your tables are keyed and joined together. Since I cannot see the tables I would guess that you have a one to one relationship - check the keys on your tables if two of them have the...

If I understand what you are saying you should be able to change the properties of the subform to allow additions but not allow edits or deletions. In the properties of the form there are some selections take a look at them and see if that gets you what you want. GumbyD

Looking again at the SQL - there are no parameter values specified in the SQL statement. Try coping the SQL into a new query and see if the double prompt still occurs. GumbyD

Your code needs to check to see if there is value in that combo box because you are using in all of the cases except the last one. When it hits the cases calling for a value from that field it wants a value not a null. If you want the customer field to be selected before the case statement is...

If you create a new field on your query that is DateEntered:[Enter date] --- or whatever you parameter says. Then on your form you will have a field with the parameter value in it. GumbyD

Did you enter the "Enter SS No " into the parameters windows on the design view of the query? If the characters and spacing are not identical it will prompt for the parameter entry and the entry in the body of the query. GumbyD

Try this expression: CreatedDate: DateSerial(Year(DateAdd("m",-[Enter Month Amount],[YourDateField])),Month(DateAdd("m",-[Enter Month Amount],[YourDateField])),1)-1 Make sure that you go into the query parameters and add "Enter Month Amount" as an Integer. GumbyD

Couple things - you have some spaces in the field names in the where clause - that might be part of it. Try the following: Where (SerivceB1 or ServiceB2 or ServiceB3) and Not ServiceA1 and not ServiceA2 and not ServiceA3) GumbyD

Dan - You can run Access in that environment but it sounds like you may be pushing the limits a bit. We have some clients with large numbers of users on Novell servers and the main problems that we see are the record locks and file locks on the server are not set high enough. Have you...

Access references some outside code sources where it stores much of the functionality that you can use in the program. One of files it can reference is the DAO. Which I am using in the code I have written for you. To set or check to see if the reference is in place: from the database window...

It appears to me that you are using EmployeeID as variable but it is not Dimmed in the code. Are you pulling the EmployeeID value from the table? If you changed it to read: Private Sub Command2_Click() Dim Conn As Connection Dim rst As Recordset Dim strSQL As String Dim EID as String EID...

ccocom - Were you able to get that to work? GumbyD

Set the Unique Values property of the query to "yes" GumbyD

Try this for the GST field =[currencysymbol] & format((Sum([Amount])*0.04),"0.00") and this for the total field (TEXT127 field) =[currencysymbol] & format((Sum([Amount])*1.04),"0.00") GumbyD