Search results

I think I've hit on a sensitive subject. Ok, I know this thread has diverged a bit, so let me explain my situation. I understand about setting up a FE/BE database. The actual programmer in my departement, who is always 'too busy' working from home to help me, insists that replication be used...

Yes, I understand that replication is a solution for resolving data lock conflicts. However, because of the fact that many users will be simultaneously using this program, I have chosen to do this. In no way did I think this would speed things up. I was just trying to mention that it indeed...

More Details: Query FilterPatients - This is the recordsource for the form Select TableA.*, TableB.criteria1, TableB.criteria2 . . . From TableA Inner Join TableB on TableA.PatientID = TableB.PatientID Where Name like Forms!MainForm.NameFilter AND AGE < Forms!MainForm.AgeMax . . .; Query...

I have a rather complicated DB that is running incredibbly slow. Access is not in my job description so I'm asking for advice. Pardon the rather lengthy description. DB Info: I have a DB for screening patients for a clinical trial. Essentially there are two tables, one for patient demographics...

Ok, figured it out. My problem is I was trying to call a subroutine from the event procedure property. I guess you have to have a function, not a sub.

More info. If I do cont.OnGotFocus = " = SomePublicFunction('blah blah blah')" where: Public sub SomePublicFunction(text as string) Sometextbox = text end sub Give this error: "The expression you entered has a function name that Microsoft Office Access can't find."

I agree, I would have additional hidden fields, like length1, length2, . . . radius, etc. For the combo box update event procedure have a select statement for each case, square, rectangle, circle, etc. make the neccessary parameter fields visible. Then before doing whatever your form does...

For a research study I'm writing a form to screen possible subjects based on various criteria stored in a table. The table essentially has three columns: field_name, Criteria_short, and Criteria_long. The form is pretty busy so there is only space for the short description of the field. e.g. "No...

Programming and DB management is not in my job description, I just got handed some projects that our house programmer didn't have time for. All of her databases are set up as replicas and I have no clue why. It's nice to hear I understood this correctly and to confirm that my coworker is smoking...

I have just finished putting together a database for a lab inventory. I've got all the modules, forms, relationships, etc. just how I want them. Now I'm wondering what is the best way to deploy this. The database links to some existing tables that I have no control over and also uses some new...

Thanks all, some great ideas and examples. My questions were definitely answered.

@ ChrisO, no that is not actual code, and I realize it is not proper cased Anyway, the way I was going about this was a total headache. I just made copies of my functions in the same module and directly updated the me.fields directly and avoided the use of a user defined type. However, I'd...

Yeah, sort of, but in this case I would like nulls instead of zero length strings. Also I don't know how to handle values that don't get defined. e.g. function1 only asigns formstruct.field1 when function2 might assign only formstructl.field5 I only want to update the form to...

I'm very inexperienced so I may be way off here, but you could try dim newrs as recordset set newrs = currentdb.openrecordset("SELECT * From " & attnset.name & " Union All SELECT * FROM " & strengthset.name &";")

I have a form with about 15 fields, we'll call them Field1,Field2, etc. With the exception of the primary key, all the fields can be null. I have a type defined, we'll call it a FormStruct, with all it's elements equivelant to the form fields and all are variant types to allow nulls. i.e. Type...

For the SampleID criteria, wildcards were involved and therefore needed to exclude nulls with an AND statement. For the other two fields (numeric data) I had them as x = y, but should have been x like y because the input is a string and then actual field was not. I want to be able to see the...

I figured it out. The error was coming from the fact that the criteria for the numeric fields was "items.PK = ..." and should have used the LIKE expression, i.e. "items.PK like ..." Also I found it neccesary to change the first criterion to also have "(... AND forms.tubetrack.SampleID Is Not...

That doesn't work. This original code is simplified (still gives the error though) and once I figure it out it will have a few more fields and a join.

I have the following query SELECT items.itemKey, item.sample AS [Sample ID], item.PK AS EMPI, item.account AS Account FROM items WHERE (((items.sample) Like "*" & [forms]![tubetrack].[SampleID] & "*")) OR (((items.PK)=[forms]![tubetrack].[EMPI])) OR...

I figured it out. I had a join in my query that should have been a right join but was an inner join and that was filtering out the majority of records from my table.