Search results

I've been looking around and it seems to be impossible to connect to an mdb file on an ftp (for Access 2002 and below). I'm using Access 2003 so does anyone know if it's possible in this version?

Was that just a random suggestion? I didn't see anything useful related to templates. I did do a google search on "access report templates" and it looks like their idea of a template is copying a pre-existing report and changing the control source. I can make something like that work though...

Trying to make code to auto-format a report. Actually what I need to resize most of all are labels. Using the wizard they never fit right off the bat. The text boxes containing variable data are smaller and usually don't need resizing.

Is it possible? And by overflow I mean text that isn't being shown because the text box is too small.

I'm sure everyone thinks the report wizard does a terrible at formatting the columns. I'm usually moving text boxes and labels and resizing them because text is being cut off. Is there any way to create a custom report style for the wizard to use or change defaults? I'm trying to avoid...

I'm on a project to build a database for the stores in our area. Things like managers, banks, and partners obviously should be in seperate tables. Most of the information though, seems to belong directly in a table of stores. Basically each record is a store and there will be very many...

For those of you who are interested, I finished the project. Making the queries was a pain so I had to create a custom Query class to make the seperate clauses (SELECT, FROM, WHERE, etc.) and put them all together. The actual display wasn't very hard though. I just made up a subform...

I don't have the database finished so I can't really comment on the structure. However, I know the database will be used by multiple people, very likely at the same time. I've heard it's a good idea to split the mdb into a frontend and a backend so I've already started that process. I have no...

Success! Okay, I made a little workaround. Here's my updated code:Private Sub txtDate_AfterUpdate() On Error GoTo Err_txtDate_AfterUpdate Dim dtCurrent As Date Dim objResult As VbMsgBoxResult ' Stop if control is empty If (Trim(txtDate) = "" Or IsNull(txtDate)) Then...

I added that bit and it still gives me the error. I don't need the code to work exactly like I want it to. However, as long as the user enters "No" to my warning message I would like the date box to maintain the focus. If I add SetFocus commands to BeforeUpdate, AfterUpdate, or LostFocus...

I have code in a BeforeUpdate subroutine of a text box to validate the date. The user can choose to keep or discard the value but the warning only appears if the date is in the future or at least a month old. This is my code: Private Sub txtDate_BeforeUpdate(Cancel As Integer) Dim...

Can I detect if a certain library is missing? If so I want to execute a different set of code in an attempt to provide the same functionality.

At work I don't always use the same machine. Sometimes the machine has an older version of Microsoft Office and when it does I'm missing a few library references. Is there some way I can have these library references without installing the newest version of Office? I'm using VBA 6.3, not VB.NET.

I have a pretty complicated query here. I have a series of stores with sales data. Sometimes I want to consolidate the store information so the total sales of stores {1,2,...,n} would be totaled as a single store. I can do that and show it as a summary, but when I try to compare the totals...

I maintain a database that is used by several people in my office. Only about 4 different people actually use the database but I would like the database to have multi-user support. As of right now the tables, forms, modules, etc. are all in a single mdb file. Can someone recommend a method...

I want to make a table that is dynamic (for use in a combo box). Basically I want the table/query to display the last 5 two-week periods. It is every two weeks from a specific day though. I'm not pulling any data from a table, I just need a column of dates. So I would want my table to look...

I could easily fix this problem (I hope) by deleting and recreating my form, but I'd really like to know what's going on. I made a simple form that relates to a single table. No big deal. Somehow, through all of my editing and coding, whenever I open up the form all of the controls are empty...

Looking at table.jpg you can see that each SwitchboardID is a group, each ItemNumber greater than zero corresponds to a command, etc. This is the way the switchboard is setup if you use the switchboard editor. My table was setup fine, I just didn't setup the command buttons correctly. The...

I tried to make a modified version of the standard switchboard. Instead of clicking an option (that opens a new switchboard) and the list refreshing, I wanted to have the main options on one side and the sub options appear on the other side. So if "Option 1" is pressed it would show a certain...

Never fails that I answer my own question. The control source and the text box itself had different names for "Period A" and "Period B". For everything else they were the same so I was under the impression I had to give the name of the control source or even the label.