Search results

I think the simplest approach to this could be to create a query that returns a count of upC numbers using the form as criteria. If the count is >0 there must be a match. So you could load some could behind the form like if Dlookup("Count","MyTable")>0 then Me.Undo Me.txtUpc.setFocus...

This is driving me batty, but very difficult to describe, so I apologise in advance for the length of this post. I have a table called tblPoolParameters. This table has the following fields: Construction Sanitiser pHControl Parameter TargetValue UpperLimit LowerLimit ReportType Of these...

I have a subform set up as an order detail form. This contains a combo box with details like Part Number, Description, Price. When the user updates the combo bx by selecting the appropriate description, I want to populate the column Part Number, and price appropriately. To achieve this I am...

This is an error caused by trying to go past the end of the recordset. The simplest way to fix this is to add some error handling to your code. If you haven't got to the point of writing error handlers, you could cheat until you learn how by typing On Error Resume Next. HTH

I have a form in datasheet view that lists all parts. I am trying to pass in an openargs property, but this makes the datasheet revert to Form view? I have two problems: 1: I have a combo box called EqModel on the form, that I am trying to search against in a recordset for openargs. This...

I have been playing with this for a few days. I have a table set up for personal details, name, email. This is the form, we will call main form. Then there is a subform for phone numbers. So the person can have as many phone numbers as you input. Another subform on the main form displays...

I am making an application at the moment that includes the ability to attach parts diagrams. As you may have guessed I do not know how large the parts diagrams are going to be. Therefore I thought I would stretch the image to fit. This doesn't work properly either, as the image becomes...

I have a field bound to my table called Type. This lists a general type of object something like Car,Truck, Boat. This is a lookup to another table that contains all types. I then create an Alias name for some of these types, not all, through another table, called TblAlias. This contains the...

Just a thought, I don't know how practical this would be. Make a table of the big four with ID. Make a table of Dates and relate the bigfourID to that. This then generates a uniqueID for the date and question. Use the uniqueID as the relating table to one or two new tables for the text and...

I am trying to make a super compressed form of information. I have a series of sub-forms on the master form to achieve the desired outcomes. For the main this is working well. In one sub form I require a tabbed form. I am trying to force the recordset to be one recordset to facilitate...

Problem solvered. Private Sub Combo14_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Dim strSearch As String strSearch = Nz(Me.Combo14.Column(3), 0) Set rs = Me.Recordset.Clone rs.FindFirst "[ClientID] = " & strSearch If Not rs.EOF...

This is difficult to explain, so if it appears a little vague I apologise in advance. I have a main form set up that record names and contact details, this contains a subform which includes the address and details of the dwelling. As owners change we have seperated the dwelling from the owner...

You could construct a form, with a field in it, called for example txtPath. To change the code you would manually enter the new path into the text box, and click a button called addpath or something. In the onclick event you would run your code, modified as follows: Dim strPath as String...

I understood that a 97 MDE cannot be loaded in XP if this is required you must load the MDB and convert it to MDE once in XP. There is something about this in Microsoft knowledge base.

You could try making a top 5 and changing it in SQL to 1. However, Access will return all records that match the returned record. So for example if the criteria you use to deside top 1 is date, it will return all records for todays date.

I don't know if this is helpful, however, I have been thinking about a system for some time. Essentially take the data and hash it in a known way for example instead of A,B,C,D, translate to ASCII values and multiply by pi. The receiving end divides by pi and reverses the ASCII value. I think...

Thanks I downloaded that file yesterday, but haven't gone through it yet.

I created a security file for my database. I placed this in my Securitytry folder on drive D:. I cna get this to work exactly how I want it to, and copied it to my distribution folder. So far so good. I then went into the workgroup administrator and told it I wanted to join the normal access...

Create the report based off the table your form is based on. Write this as a SQL statement into the OnOpen event of the form, setting the recordsource property to the SQL and make the SQL point to the current record you want to print. In the onActivate for the report test if the form is loaded...

I think your total field is bound to the table and consequently you cannot change it. Try making it unbound, you do not need to save the value anyway as it is calculated. I cannot imagine why you would want to change this value, unless it is for a discount, delivery fee or what have you. This...