Search results

Hey buddays, I have a form with a bunch of Count totals in the footer. There are 12 different areas with a number of projects in each area. So, I'm counting the total projects, and then I'm counting the instances of an area in the area column...12 times. In the query, I have 12 different...

You don't create 80 versions of the Front End. You put the Front End on your server, and tell your co-workers to download it. Your Back End is on the server as well (hopefully in a different, hidden place!). Whenever you make changes to the Front End, you upload it to the server, and tell...

This might be a bit off-topic, but ReAn gave me some good tips for sharing databases in this thread. The second post in the thread is the informative one (the rest of the thread gets into a discussion of enterprise level RDBMS). If you're web-savvy, an ASP front-end might be the way to go.

Alas and woe; I have been stricken with the "Cannot find the object MSysDb" error. :( (Note: MSysDb is not to be confused with MySysDb.) My DB is unopenable. The objects cannot be imported into another database. The Jet Compact Utility from Microsoft's website cannot compact the corrupted...

This thread might help.

Hey Muthafishy, You sound like you're on the right track, and willing to do the legwork, but let us clear up a couple of terminology/general practice things for you. Hopefully this will get you on your way! First, the term "linking" tables usually refers to having a seperate Front-end and...

Again, without an idea of your table structure, it's difficult to give you advice. I've got a feeling that what you want is something like the following: -- You are keeping a list of projects, stored in a table (tblProjects). Each project has a Requestor, all of whom are stored in a table...

I'm going to go out on a limb and assume that eholtman is in the beginning stages of becoming familiar with Access, am I right? Just a hunch... If so, then I suggest you tell us more about your table structure (especially if it's coming in from Excel, it's probably 'flattened' and needs some...

Bump Just another bump. C'mon, somebody's got to have some tips, right? ...right? ...right?

Bumpy Bumperson Just a litte bump action. :) Anybody have any ideas? :confused:

Hey there buddays... I have a rather large database that is split into a frontend and a backend. The backend resides on a shared drive while the frontend is on individual users (about 5 or 6) desktops. I can't do any administration on the shared drive, i.e. I can't hide the backend from...

Are you talking about a command button on a form made with a wizard, or are you talking about a command button that's linked to a previously created Macro object in your database window? If you're talking about a Macro object (possibly triggered from a command button), you probably need to...

Hey Jacob, I'm assuming you set up your combo boxes early on using the Access wizards, right? So, when you plunk a combo box down, the wizard launches and asks the following: "How do you want your combo box to get its values? I want the combo box to look up the values in a table or query. I...

I only had time to take a quick poke around, and I didn't get a chance to modify it and try it out (got deadlines of my own, brothuh) but it looks like Access is creating a new record every time BECAUSE you have the main form in "Data Entry" mode. What it sounds like you want is the ability to...

We need to see the underlying table structure in order to see why the form isn't working. If you can post a copy of your database, then folks on these boards can analyze it and give you some feedback. Try compacting your database using the "Compact & Repair" option under the Tools menu in Access...

Hey O, sorry it took me a while to respond, You don't need a VB editor - Access has one! While Visual Basic for Access is a bit different than normal ol' Visual Basic, it's similar enough to futz around with. You can either create new modules which you can call from different events, or you can...

Kraj, Rich, thanks! I'd read about the NZ function before, but didn't realize now was the time to use it. Shweet, budday, shweet. It's working like a charm.

Hello buddays, I'm almost sure I've seen this problem addressed here before, but I wasn't able to locate a relevent thread. I've got a calculated text box ("txtTotalScore") in the footer of a subform. The subform contains a a tab box with three tabs. Each tab has another subform, with yet...

You were a little unclear in your description (you mention using tables, and then your description of which form is the parent form and which is the subform is confusing), but as a general idea, I'd suggest: 1. checking the Master-Child link of the subform (in the properties of the subform, NOT...

This is a real low-tech way I picked up from Mile/SJMcAbney - I can't find the thread so I can't post a link, but here goes: Make the background transparent on the text box you want to change. We'll call it txtTrans1 for now. You also have your Yes/No combo box, right? Make a copy of this...