Search results for query: *

Hi, Upon entry of a new record I want to prevent duplicates. I relize that I can set an Keys on the table, however that would change the DB structure. Iam trying to prevent duplicates in the VBA but having some issues. I am getting an error 91 on the Set rst. Will this work below? Thanks...

Hi, Is it possible to convert inventory from lbs to kg? The inventory is ordered in lbs but we track the material in kg? Is it possible to convert this? Thanks

What would cause data to show correctly and competely in a query but not a report. I am filtering a query and when it runs it displays all the records. On the report it runs onto page 2 any records after page 2 doesn't show. However, my counter displays the correct amount that should show...

Hi, I was wondering if this is possible in a text box that is set as a Memo field. I need to copy something from Word that is in formated in a table. How can I copy and paste this into Access (text box) without losing its formatting? Thanks,

Hello, How can I send an email to a title that references an email address in a table. For example IT would reference one or more email address? Thanks, DoCmd.SendObject , , , _ "IT", , , _ "subject", _ "message", _ False

Hi, I have a report that contains a subreport. If the subreport contains no data, I am going to have a marker visible on the main report. If Report.srptDiscrepency = False Then Label16.Visible = True End If Or I am thinking if a particular field on the subreport isnull then...

Hi, How can I format a field to display a certain way in a combo box. For example, I am trying to display the values in the combo box in a 3 decimal format. 1.010., 1.000, 2.500, etc. I don't know if this is the correct way in the field type in the type I labeled it as currency and in the...

I have an unbound listbox that lists 6 different types of reports. The rowsource is tblReports. How can I go about select a specific report from the list and have it go to that report? Thank you,

Hi, I have two tables that are intersection entities. Both tables have a field called EmpNo. Table 1 has contains EmpNO. How can I get it so that Table 2 also to hold matching EmpNO. A query Update will not work because, the joining filed is not unique. However, If I can get EmpNo field...

Hello, I have run into a slight design problem. I am creating a Training database. I have two types of trainings SOP and WI. Each training is a M:M with the employees. Each training has its own Skill Sets and each employee can be assigned M:M skill sets. Lets say I go into the database and I...

I am having a problem with adding an AND into the WHERE below. The user has can not login unless they USERID matches and there PERMISSIONID which has already been assigned. This works but I want to add an AND into the statement. ("SELECT tblemployees.EmployeeID AS PersonID...

Hi, I have an option box that will filter a combobox in a subform. I am getting an error Jet engine could not find the table tblGroupSet with matching field(s) 'Groupset' Private Sub grpGroupType_AfterUpdate() Me!sfrmTitle.Form.cboGroupSet.Value = Null...

Hi, I currently have a report where I am quering with a Group by. One field is a date, which I am doing a filter on a DATE TO and DATE FROM. I currently have this expression on my query. Between [Beginning Date] And [End Date] I want to get away from this and I created two unbound fields on...

Hi, I have checked the forum but I wasn't able to find a solution. I have a query Parameter that asks for user Beg Date and End Date, when the user goes to click on a command button. If I click cancel button, I get the 2501 The OpenReport action is canceled. On Error GoTo ErrHandler...

Hi, I have a filter of employee names that belongs to a form/subform. The employee names are a subform and sometimes there maybe 1,2,3 names in that subform. I am trying to print out a report that selects a name from a combobox. I am only trying to print the records of the employee that are...

Hi, I am trying to sort on an aggregate function in an Access Report. Basically, for a number of items I am trying to sort on by a =Count([Item]). How will I be able to do this. Thanks.

Hi, I hope someone can lead me in the right direction. Currently, I have a lookup table in Excel that converts various units of measure. For example, I will enter in a number for Lot Size: 5 and then select the unites of measure: mg (dropdown) Then I select Packagesize: 10 and then select...

Hi, I have 2 unbound listboxes, 1 list box contains the items and the other contains what items have been selected. How can I the items in listbox 2, into a table. Right now, when I change the records, the listboxes remain the same

How can I have a form only Print only the first subform record?

Hi, This may be a common question and I have looked around but with no avail. I am running a report from a form that has a subform, too. 1.The sort is by Date (Month) 2.Then I am sorting by the names of the subform (usually 1, 2, or 3 names) 3. Then I am sorting by record number...