Search results

Thanks but I already did that.

I wrote an application in VB that uses ODBC to connect to an Access database. This works fine for one client machine who is running Access 2000 (Windows 2000 Pro). But the second client is running Access 97 on Windows 98, and it seems like the connection isn't working. I am using a SQL Insert...

Create a table tblMOS Fields: MosID Autonumber MosValue Text (5) or whatever length it needs to be Create a query (qryMOS): SELECT MosID, MosValue FROM tblMOS; Create one form form all of the text selections you need to make to fill out a letter (frmDataEntry). Place a combo box...

Look around in Help for info on the order of events with reports, I have found it in there somewhere. I don't recall offhand the exact order of events, but you may be trying to close the barn door after the horses have escaped. HTH

I have found that formatting a field in a table doesn't really "change" the value that is stored, it only changes the appearance to match the chosen format. So even though the table and the query feeding the combo look like 5.0%, Access is really storing the 0.05 value. Isn't there a way to...

I don't have Access on the PC I am working with right now so I can't look at your mdb but a common problem with form/subform is improper choices of the master field/child field relationship in the properties of the subform. Perhaps that is where the problem lies. I have seen people try to...

Look in Help under pass-through queries, that is one way of doing it.

A lookup table is a plain regular table, another commonly used term for the same type of table is master table. They are called lookup tables because they normally have just an ID field and one text field and are often used to feed combo boxes such as you would be using. It is not anything...

It sounds like the sentence to be printed is determined by the choice or choices that are made as in the example that you gave. If that is the case, then choosing a MOS value and then an ASI value would determine the sentence that they are inserted into. If that is ALWAYS the case for all text...

As an addendum to my last post, I just noticed that you mentioned that you needed to tie each text entry to a particular sentence. I would need to hear more of an explanation as to why that is necessary. But you could add a sentence id field to the large table, tied to a sentence lookup table...

Here is the approach that I would take: Let's say for example that you have 20 different entries that you want to have a person make a selection on, and those 20 entries would be inserted into the text. I would create 20 lookup tables to contain the list of possible values to choose from for...

Try: SELECT Count(reg_type) FROM tblRegistrants WHERE reg_type = "NMG" OR reg_type = "G"; That will give a count of the number of girls (member and non-member combined) registered. You can use variations of that same query to get a count for any reg-type or combination of reg_types...

You can directly link a subform to a master form by filling in the Master and child fields, this should negate the need for having a separate query to try to link them and having to requery the subform on a change of facility id on your main form. HTH

This is how I work with recordsets Dim rstMyRecordset as Recordset Dim dbsMyDatabase as Database Dim whichSet As String whichSet = "SELECT tblHistory.Comment, tblRma.SerialNum, tblRma.RmaID " & _ "FROM tblRma INNER JOIN tblHistory ON tblRma.RmaID = tblHistory.RmaID " & _ "WHERE...

You would need to explain what you are trying to accomplish with this database. I can't imagine a need to have the same field as all or part of the primary key of 7 different tables. Maybe what you need is to have SO Num as the PK of a "Main" table and then referenced as a foreign key in the...

I left out an example of the connection string argument, here is one: strConnect = "ODBC;DSN=TestDatabase;SERVER=ServerName;UID=UserName;PWD=SecretPassword;" This example uses an ODBC connection, to use it you need to set up an ODBC datasource ahead of time thru the control panel. HTH

Look up table objects, field objects and their properties. The datatype is one of the field object's properties and you can update this from code. I don't have Access on this PC soI can't look up the specific syntax, but you should find some examples in the Help files. Good Luck

Try something like this. Use the primary key of Table1 as a hidden field in your listbox. Write a query: DELETE * FROM Table1 WHERE YourPrimaryKey = frm!List32 (btw, give the listbox a meaningful name) Then put a delete button on the form, in the code behind the on_click event of the delete...

I think you must have tried an import that didn't succeed part way through, but ended up "stealing" those autonumber values. Try deleting your local table and reimporting. If that doesn't work then import only the table structure, link to the remote table and do an append query into your new...

You could create what is called a recursive relationship within one table. It duplicates the one-to-many relationship that is common across two tables. In your case it would work like this: 1. Combine your reach and site tables 2. If you don't already have a numeric primary key field...