Search results for query: *

Ok, I have a handful of front ends that we use in a Distribution Center environment. In order to prevent file sharing/corruption issues, I make a copy on the local drive. Well . . . now our IS department wants to really limit permissions on the c: drives. We can only save things to our...

Simply put, I have a datasheet functioning as a subform. The user is entering questions, and I anticipate they will want to rearrange the order of these questions from time to time. I want them to be able to select a row and click a button on the main form with a "Move Up" type of...

I am working on a project where we will have one back end file and mulitple front end files (one for each department). These front end files will be replicated with one replica going on each computer. The OS's don't share well and it will save network resources, so this appears to be the only...

I am planning to create replicas of a set of small front end db's and make a set for each computer in our distribution center (~30) that will be saved to its own hard drive. A large part of my motivation is that it could be a great way of distributing design changes. It would also prevent file...

At work we are having a few difficulties. Let me explain. Some computers are on Win 98, others on Win 2000 with one or two on XP - they don't files share well. The mdb's get locked up. Then we have to compact a repair, but everyone has to get out first, and we working in two buildings - this...

I have a main form where the user enters a few tidbits of information. Based on the type of meeting selected a subform will show the appropriate number of combo boxes. All of that works beautifully. However, if a combo box has a value I can't ater set it to .visible = False (if a different...

I am experimenting with an idea, but researching this has become quite the bear . . . I want Access to, in response to user input, create various appointments in the calendar. Sometimes things will be double booked and that is fine, even normal - it's more for documentation purposes. The...

I hope someone can help me . . . I am not new to Access but have never used Data Access Pages and I want to make a Page that works very much like a form only am not sure if that is possible . . . I want the user to be able to select their department from a drop down, based on that response...

I am putting together a small "application" to help us manage a particular kind of material in our distribution center. To that end, I have a form to search records. Based on whether a combo or text box has a value it builds an SQL statement that is then sent to the subform. Then...

I am having a bit of difficulty with the last part of a project I am on. I have a form with a subform at the bottom. Based on the selections from a set of combo boxes across the top, my form will assemble an SQL statement. I need to pass this into the subform and refresh/requery it, but...

I think the title kinda says it all. I have this form with only unbound controls. There are about 7 or 8 text/combo boxes that the user will enter information into - one of them being the txtDate control. Whenever I try to pull the value of that text box it simply comes up blank - and I...

I have a report with two subreports. I takes about 40 secs to open completely and when it does all of the information displayed is correct. The problem I have is that, when I go to print, it gives me the above error, and the printed report does not show the contents of the subreports. This is...

Hello, I need some guidance on something . . . I am working on a Db where I find it necessary to often collect information from many tables (all essentially containing the same info) and put them together into one recordset. Right now I am using a string of append queries, making my...

Well that sounds a bit more ambitious than I think I really am. I have written some code and looked at past posting trying to riddle this away . . to no avail, alas and alak!! Someone please help here is the code, and yes the table is named "tbl" and form is named "frm&quot...

Does anyone here know of a better switchboard manager? There are a few changes I would love to see made, among them - and most obviously is having the ability to code 10-12 buttons on a page instead of the meager 8 (why only 8?!?!?). Anyhow if anyone knows of an improved one out there I...

Help! For a long list of reasons I have elected to create my own "security" to a new db I am putting together. I have hit one snag. I have built a form for users to enter userId and Password and have all the desired actions all perfect, EXCEPT . . . What is the best way of making...

I am embarking on creating my first TRUE database (you know the kind with tables I make and all . . . ). Well, one of my concerns with the way Access handles data in forms linked to tables. I want to make sure that no changes are saved to a table until a save or print button is clicked...

My question I think is a bit odd - and yes I have read up on this - I am working on a DB at home that I hope to propose at work as a solution to Runaway Speadsheet Syndrome. SO, the problem becomes two fold, first what is the best way to implement the security? Should this be the last step...

I am working on a database that I am trying very hard to keep modular. The goal is to make it very easy to use even for the non-database minded. Problem? This is for a distribution center and one table is for equipment types (and those alone) another table records wether or not a person is...

I am working on a very simple database, but have hit a wall. What I need is a way to "lump" order entries into weeks. By that I mean if something is added on Monday And Tuesday they are on the same order. Then next week would be seperate. I want this to be invisble and thoughtless...