Search results for query: *

Greetings. I'm using Excel 2007, in case it matters for the situation. In dealing with a workbook made up of 42 different worksheets, there are many cross populations occurring in that one piece of cell data will be used in a formula to feed a value and that value used in another worksheet...

Greetings. I’m very stuck on this and I’m sure it’s easy (based on what I’ve recently read)... but obviously things are beyond my skills or my environment is actually different. (I'm sure it's me.) Using MSAccess 2002. I have a table of Project Meetings [OTM], containing project number [PNUM...

Greetings, I’m trying to achieve the following and don’t seem to find what I need in the on-line help nor here… Need to collect, store and report on the following data: Project number, Mtg-1 Date, Mtg-1-Attendee1, Mtg-1-Attendee2, Mtg-1-Attendee3, Mtg-1-Attendee4 (Up to 20 …) Mtg-20 Date...

Greetings all! I am looking for a way to programmatically unlock a workstation from a MS Access application. Scenario: workstation is locked (Ctrl-Alt-Del/lock computer) and this application would be run from scheduler in background to “log in” as the person to unlock the computer, allowing...

Greetings. Okay, this is really a really out there type of issue. Please be gentle in any replies… Background: Running MS Access 2002, running tons of macros to update data and then generating reports. These updates run at various points after midnight until the big push with the reports...

Greetings. I'm embarrassed to put this out here, but the brain is fried and I'm obviously not seeing the obvious... In a query, used as the basis for both other tables and for reports, I need to calculate percentages, like the percent complete (using two numeric fields, which could have...

Greetings. I send out tons of spreadsheets to remote office/workers for them to update certain cells (if needed) and return to me. I'm looking for a way to detect that the value has changed from the time I sent it until it's back to me. For example, cell D30 was sent out as 50 and they send...

Greetings. I have some daily transactions in a tab delimited text file which I import into my database and then file the transaction files to a folder. I found out there is a flaw in one of the update queries in the database and now I have to fix about 39000 records. All of these records are...

Greetings. Trying to set up a macro condition, so that if the value of a particular field in a table is "match" then that line of the macro will run. I can't seem to get this to take table![tblname]![fieldname] = "match"; like the syntax shows for forms or reports. I'd...

Greetings. Trying to group together some information that comes in from another system, and I have NO CONTROL over the structure. It's sort of a take-it or leave it (the old, "we're doing you a favor…"). Here's the structure I get: Project then Task then Hours. There are no null...

Greetings. Looking for some help with automagically running a macro in an MSAcess database using the Task Scheduler. I've found the other threads here describing the process and they are a wonderful help, but I still have a sticky wicket. Mainly thus: The database has a database password...

Greetings. I want to print out table information, like what you see when you open a table in design mode... field name, data type and the description. And truthfully I really only need the field name and the description. The Tools|Analyzer|Documenter gives too much information (100 pages just...

Using Access 97 Greetings. I'm so lost on this I don't even think I have any of the terminology right! So let me just sort of say it in English (as it were)… In table one (ProjectTracker) there is a ton of data regarding a project. In table two (ProjectActivity) there is date and hours data...

Using a WSH script to do a FTP from the host, one of the files is a generation file which has to be referenced within parenthesis, when it's processed, the () is lost. I've tried signle quote, double single quotes, double quotes, etc., to no avail. Anybody have any thoughts about how to send a...

Using Access 97 I have the need to regularly transfer a table from a local database into another one on the network. Using a macro that runs a series of queries and then the copyobject process, I am able to achieve the copy, having to manually accept the overwriting of the table. However, for...

Topic: Disable menu bar and tool bar based on user, using VBA -> Using Access 97 <- Greetings. With the help of this forum, I've been able to distinguish a user, and open the appropriate form and then suppress the database access window in our shared application. Now, I need to turn off the...

Greetings. Have the need to connect to the internet via dial-up from within a process in MSAccess 2000. Basically from a box on a form, want to kick off the event to dial. From there will run another application, but for now, my stopping point is trying to do the dial-up. I can't find a...