Search results for query: *

Hi, This is probbly more of a networking question than an Access question, but I have always received good advice here... I have a split db. I want to place the back-end in a different Active Directory folder than the front end so as to prevent users from copying the tables to their hard...

Hi, I am trying to upgrade the security on a multi-user database located on a network. I have utilized the Access user level security. Every group's permissions have been assigned. What I need to do is to have my users enter the db via a shortcut that will take them to the necessary mdw file...

Hi, I have a query that returns results based upon a user's selection of different fields off of a form. The query works fine except for when I am trying to reference two fields to obtain results greater that [FIELD_1] but less than [FIELD_2]. It works when the Where section of the SQL only...

Hi, I recently split my database and now everything runs really slow. From other posts I can see that this is a common problem. One of the solution to the slowness that I have found is to have the SQL run on Form Load instead of referencing the query in the Record Source Property. I can cut...

Hi, I am trying to make an automatic footnote function in Excel. What I would like to do is to have the user enter some notes next to a column of numbers. The note is text. These wil become footnotes. I would then like (after button click) to have the notes cut and pasted at the bottom of...

Greetings, I am new to VBA in Excel so pardon any newb questions... I would like to create a "footnote" type funcion where a user's input would be entered into a cell - copied to an adjacent worksheet - and then replaced with a footnote number. In addition two other cells on the same row...

Hi, I have a query with five tables -- all of them non-updatable linked ODBC. The results of my query are about 1900 rows and 42 columns. Everything is great except... When I try to dump the query into Excel the whole DB crashes. I have tried to limit the results and do a piecemeal transfer...

Hi, I need to join two tables. tbl_Budget has three fields that I need: [Fund] [Account] [Budget_Amount] tbl_Actuals also has three fields that I need: [Fund] [Account] [Actual_Amount] I need to compare like [Account] within like [Fund]. The problem is when an account exists in the first...

Hi, I need to make my relational database into an excel file. In the database there is: tblEmployees tblJobHistory tblDistributionActual There is 1 Employee per JobHistory, but 1 + DistributionActual per JobHistory. I need to make a "flat file" where for each Employee there is one record...

Hi, I have a db where an employee's record can have 1+ accounts. (tblEmployee linked to tblAccounts). One of the auxillary data sources contains info on each employee, but is a flat file. That is, each employee record has only one record and 1 - 10 accounts (fields labeld: Acct1, Acct2...

Hi, I lifted the following code from an old thread. It works fine except it does not convert the "cents" into text when the "cents" = a number divisible by 10 (e.g., 10, 20, 30, 40). I have gone through the code as best as an amature can, but I cannot for the life of me figure out what is...