Search results

thank you. thank you. thank you. you saved me the hassle of manually setting up the connection on 40 machines. thanks to RichardJ for posting the code. our main db is an access FE / SQL Server BE. the upgrade wizard in access handled the connection to the sql backend for that. the one...

first, thanks for your help. here's everything. the mdb file is not split. it's a small db that isn't heavily used like our main one. the mdb file resides on the server. i'm opening the mdb file in access 2000 on my machine and trying to set up the odbc link. i go to "get external data"...

i'm not sure how to reference the sql server database in the "DSN Name" box. the DB is called HFKDB, and it's resides on the server called SGI2. that's where i'm stuck for now.

i have a small access 2000 mdb on a server. a combo box in a form populates its list with a field in a table in a sql server 2000 database. if i go through the steps and link it on one machine, the connection works, but it won't work from another workstation. i get: ODBC -- connection to...

i know there are existing threads on this, but i couldn't find the details i need using the forum's search. we have access 2000 mdb's as frontends on 35 workstations and a sql server 2000 backend. i would be absolutely thrilled if i could have the new mdb file automatically copied to the...

thank you. it wouldn't work as the control source on the report, but i made a field in the underlying query based on your help. that worked just fine.

i have a field, FamOrTreat, in a report. the value for that field can either be "Family" or "Treatment." to save space on the report, i want it to show up as either "T" or "F" rather than the whole word. i know this is probably very easy, but i have no idea how to achieve it. help would be...

make sure the "Microsoft DAO 3.6 Object Library" is checked in the Visual Basic editor. i doubt it's a default in XP as they're advancing ADO. also, it might help to put a "DAO" in front... try: Dim rs As DAO.Recordset Dim db As DAO.Database hope that helps.

that's perfect. thanks a lot!

i have a table containing nearly 5,000 clients and need an efficient way to find a specific one. i want a search form where i can enter part of the name, click a button and all the matching names will be returned. from there i'll be able to double-click the name to take me to the specific...

it worked. thanks a lot.

that didn't work. i get a message saying that it can't find the form. i think in the statement you have to include the main form and subform, but i can't remember exactly how. thanks.

I've done a search and was unable to find exactly what I need. I have a combo box, PerDiem, that has a list of rates that come from a table, tblPerDiemList. I have a button that opens a form, frmPerDiemRates, where you can add a rate to the list. I want to requery the combo box. The...

currently i have an accesss 2000 (.mdb) split database with security. i'm about to use the upsizing wizard to convert it to an Access project to work with SQL Server 2000. before i do that, i'm wondering if it would be best to recombine (unsplit) the DB first or if i should run the upsizing...

thanks. it worked, but you still have to click somewhere on the subform for it to go to the last record. it's almost the same as clicking on the "go to last record" button, so it doesn't really save a step. I tried to set the focus on a field on the subform after clicking the tab on which the...

I want a subform to automatically display the last record when opened ( 14 of 14, etc...). How can this be acheived? Thanks.

After I type "Dim DB As DAO Database" and try to move to the next line, I get: Compile Error: Expected: end of statement I'm using Access 2k SR-1.

When I run FillTable, the debugger comes up with "DB As Database" highlighted. The error message says: Compile Error: User-defined type not defined "Database" does not appear in the pop-up list after typing "Dim DB As". Any ideas?

Thanks a lot. I only have one more question. I'm not sure where to place the function and how to call it to update the table. I'm used to working with form modules but haven't worked with functions. Do I need to create a global module and put the function in there? Then how and from where...

Users will only be adding records, so I think I should stick with the append query. I don't want to use replication if I don't have to. I don't really like the time-stamp as a PK, but if I make [EnteredOn] and [ReferralID] the PK, I'm sure it will be unique especially when you consider the...