Search results for query: *

Our server crashed and all of the backup files were moved to a new server with a different name. My front end will not open at all. A message appears stating that the path is not valid. Holding shift while opening and F11 are not getting me any further. Is there a way to change linked tables...

Our Monthly Booking Report is pulling all Sales Orders with Document Dates within the month that are NOT backorders. The result is that I enter a new $75K order on May 4th and that amount is included in the Monthly Booking Report. We ship $5K worth of product against that order on May 6th and...

I've been approved for a grant through the local unemployment office to take computer training. I've been working with Access for seven years building dbs and specializing in streamlining data management. Module-level functions. VBA/SQL coding. Custom forms. etc... While looking for work I...

I recently had to attend a family event in a rural area about 100 miles away. When I called for directions I had to get clarification on directions like “turn left where they’re going to build the new church.” Thought others might have interesting driving directions they’ve received over the...

I was looking at leasing a car awhile back. The salesman was very enthusiastic about explaining the "Guaranteed Value" part of the deal. I could lease the car for five years and they would absolutely guarantee that the value of the car would remain much higher than if I purchased the car and...

I have a continuous form showing blocks of text for a resume. I've added a couple of buttons beneath each block of text so that it can be moved up or down on the list. EG: I click on "Move Up" for record 14 and it swaps it with record 13 and goes to that record. If I want to move it up...

I have a database in which I am trying to run some basic queries including Access built-in functions like Month, DLookUp and Now. I keep getting an error: Compile error. in query expression 'Now()' When I type the expression into the query builder, it is automatically capitalized so it...

I'm putting together a little game for my son to learn his letters. A bunch of command buttons cover a large textbox that holds a letter of the alphabet. As he clicks on the command buttons they become transparent and reveal a little more of the letter. The idea is to get him to concentrate a...

I had posted this in the Forms Forum without reply, so I thought I'd try here to see if any one has any ideas. In Microsoft Explorer, if a folder name doesn't fit in the window, you can mouse-over the folder name and a label appears showing the full name. Is there a way to do this with a list...

I'm trying to pull info from an Excel spreadsheet that contains checkboxes and comboboxes. I've never worked with these controls in Excel before. I found where I could assign the control values to other cells and import new spreadsheets based on that, but I have a lot of these old forms that...

I'm beginning work on a form to be used by people in the field to identify customers and schedule visits. I'd like to have an area of the form with one or two 'Containers' (I call them at present) where the user can drag and drop the account number and have that record added to a temporary...

I just wanted to take a moment as the calendar changes to thank all of you who participate in this forum and those that keep it available to us all. With all of the layoffs that have been in the news lately, I don't mean to be insensitive. However, the company I have been working for for the...

For some time, I've wondered why there weren't more aggregate functions like DLookup. Common needs continuously arise in our apps to concatenate fields or values or to find and replace or strip characters from strings. I figure that Microsoft is using much the same code as the rest of us, so I...

In MS Word and Outlook, you can triple-click on text to select an entire paragraph. Is there a way to turn this on for access text boxes? Is there a way to use this event for other actions? Thanks, John Use what you have, Learn what you can, Create what you need.

Any tips on linking with or importing from a Quickbooks Pro DB would be greatly appreciated. Thanks, John Use what you have, Learn what you can, Create what you need.

I'm trying to add a column (MyID) to a table to add a sequential index: 1 to RecordCount. My key field is not sequential. Basing code on several threads regarding updating values using MoveNext, I can't seem to get it to update more than the form's current field or to update all of the records...

I have a group of forms that users will complete and submit to an administrator on a weekly basis. After the email has been sent, the Web toolbar is visible on the screen and the bottom half of the command buttons in the form footer are pushed out of sight. How can I supress the web toolbar...

I have a dozen Auditors who will be completing and submitting audits on a weekly basis to an admin who will import the data to a master database to generate reports and work orders. I can't get a slot on the company server to store the DB so I have to depend on email. I had used the SendObject...

We have a db for which a supervisor has to go to the intranet, refresh a page, select & copy the data, paste it into a new excel file and then import the excel file. I was hoping to hyperlink to the site, use sendkey to refresh data (F5), save the file and automatically import it as html. Once...

I'm working on a form where users will select items from combo boxes to build a report. The combo box values are used as the criteria in a query on which the report will be based. The users are 'somewhat' intimidated by Access so I placed a subform on the main form with the query as the...