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...

sorry for the post I think I got what I was looking for. I did this test:Format([number],"0.000")

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...

That I know how. DoCmd.OpenReport Me.lstReports, acViewPreview If the list has 6 reports displayed, I select row 3 "List employees" I want to print that specific report.

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...

PHV, My dilema is that an employee has M:M skill sets employee has M:M SOP employee has M:M WI also, Skill sets has M:M SOP SKill sets has M:M WI

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...

Sorry for the post, I see my error

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...

Thanks, The AceMan...that worked....

Thanks for the reply. I think my issue is coming from here. When I comment this out, I don't receive any error messages, however it doesn't filter either. Private Sub grpGroupType_AfterUpdate() Me!sfrmTitle.Form.cboGroupSet.Value = Null Me!sfrmTitle.Form.cboGroupSet.Requery

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...

Then I get a enter a parameter value, when I do that. Like I said if I were to have it as a straight query, it works fine. I think it is because the InitiatedDate is not being pulled in?

I have one for txtFromDate and txtToDate I know when I do a normal filter on dates it retrieves the correct data. For this specific report, I am trying to determine which items have the most complaints for a specific time range and put them in order. If Not IsNothing(Me.txtFromDate) Then...