Search results for query: *

I'm wondering what brand and model of power conditioner/surge protector tek-tippers might recommend. I'm hoping not to have to spend more than 300 to 500 bucks but need sure quality.

This isn't really a big deal but it strikes me as unprofessional-looking. When I open a particular form from the switchboard a strSQL statement is programmatically assigned to the recordsource of the form's subform. Basically, a subset of records from a few different tables. The thing that...

My form has a subform whose recordsource is set to an SQL statement when a command button is clicked (not doubleclick). The problem is the records don't appear in the subform on the first click -- actually they do sometimes but most of the time, it takes two, sometimes three clicks to get the...

I can't figure out how to stop Access from moving the focus to the next control on a form after a sub executes. Basically, I'm trying to validate the value the user has just entered in tbx1 before they can move to tbx2. The values are integers and the textboxes are unbound (they just collect...

How can I, in code, cause each new instance of a popup form to appear on screen slightly offset from the previous instance?

I'm hoping someone has some suggestions for this latest problem of mine. One the things the database I'm developing will do is to keep track of tenants living in various apartment buildings. The tenants can move from one apartment to another in the same building or to another building included...

I think my approach to this is probably way off base which is part of the reason I'm posting this question. I have a sub procedure that is actually using both ADO and DAO to perform what I would guess should be a fairly simple operation -- whatever record has the focus on the form, find the...

Does anyone have any opinions on using Functions versus Sub Procedures AND in what types of situations one is preferred over the other (besides calculations, returning certain values, etc...situations where functions are required)? Thanks in advance! Vie

Hi everyone, Rather than repost my whole message of last night (0 replies): thread702-796502 Can this be done or is it not possible? Thx, Vie

Hi all, How do you show a value that is generated on the fly (not stored in a table) in a column in a subform? The value is generated in a function: Public Function GetApartmentDesignation() Dim intOption As Integer Dim i As Integer Dim strApt As String intOption =...

Hi everyone, I noticed that when creating a new table from a module using ADOX, the "Required" property for every field ("column" to ADO) in the table is automatically set to Yes. Is there a way to change this property to No/False from the create table sub? With...

Hello all, Well, actually I'm not looking to become an "expert," but I could use some advice from the experts. I'm an intermediate level Access developer. I would like to get to the next level but I don't know what road to take to get there. I have tried taking a couple of continuing ed...

Hi, I'm writing a piece of code that uses ADO but I can't get the intellisense menus to appear when I hit "." and such, as in: Set col2 = New ADOX.Column col2.Name = "Floor" col2.Type = adInteger col2.DefinedSize = 30 .Name, .Type, .DefinedSize and also the enum adInteger should...

Hi all, I need to build a table (tblApartments), through code, based on the user's input in a series of textboxes and one option group. Basically the aim is to build a table for a building (literally) where the columns in the table are ApartmentID, Floor, Apartment, ProjectID, and BuildingID...

Hello all, I am trying to write a piece of code to take a strSQL statement (created in code on the fly and saved in a global variable -- i.e., not a saved query) that will translate its selection into a selection in a multi-select-enabled listbox. For instance if the strSQL selects TenantID's...

I have a semi-complex question about a design issue. My Access database tracks people through a step-by-step process. For example each person goes through step A, to step B, to step C, to step D, and so on until they reach step X. Some steps can be skipped along the way and others cannot. As...

This is probably a pretty stupid question but I'm trying to get a query to return a range of names, for instance, all people whose last names begin with A through all those people whose last names begin with P. No matter what expression I use, it seems to be up to P and not through P. Between...

I have a strange problem and I don't know where to begin to fix it. I have a form with a listbox on it (frm1). The user selects whatever items from the listbox they want and then clicks a button which opens another form (frm2) and automatically populates a subform on frm2 with the selection...

I have a SQL statement (in code) that I would like to be able to have as many OR arguments as needed. The arguments are supplied by a multi-select listbox and concatenated into the SQL string. Problem is, when the selection in the listbox gets up around 100 or 150 or so, I get the error...

I found a couple of threads that partly addressed my question but still was not able to make the solutions work for my particular situation. I need something like the following: SELECT * FROM tblNames (join type tblDates...) WHERE (SELECT max(DeliveryDate) FROM tblDates) WHERE tblNames.NameID...