Search results for query: *

I'm not sure why I didn't do this before, I think it didn't work in all OS's we had, but just the simple FileCopy commnad is working great. I put in as an experiment and I've not had any complaints - well not about that anyhow. Brambojr

I tried the c:\progra~1 idea and it didn't work. It was a good idea. Still looking for ideas. Brambojr

Here's the code. The to and froms are all constants set in a module that is also listed below (allows me to make an updater for a new file quickly and easily). Private Sub Form_Timer() Dim fs Set fs = CreateObject("Scripting.FileSystemObject") DoCmd.RunCommand acCmdAppMaximize...

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...

Ok, now I have another mystery while working on this. Why can't it ever go smoothly?!?!? In refering to the subform I am trying to get the .SelTop and the .SelHeight. I can get the .SelTop, but the .SelHeight will always give me 0. I have tried everything, but nothing seems to work. Anyone...

Hmmm . . . I hadn't really considered your solution. Do I need to do anything to start up the recordsetclone, or does it initialize immediately? I'll find out soon. As for the rest of your email, I know that I need to change the values in the position field, the difficulty I ran into was in...

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...

This worked perfectly. I just plugged in some code to whittle it down to only the file name and well, this is exactly what I wanted. Thanks Steve101. Brambojr

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'm not sure that I understand your questions. But I can give a quick overview of combo boxes and hope it helps. You can link a combo box directly to a query, directly to a table, or put together some SQL for the combo box - all of this is done in the RecordSource property of the combo box or...

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...

On further review, here is my evolving plan: Steps: Create a master db with tables (prevent unnecessary proliferation). Split Master db. Give back end a db password and re-link tables. Create the ensuing db's (forms and reports customized to departments). Create (unsure of # needed)...

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...

Ok, at the bottom of the query area you see an area labelled "criteria." Click into this area underneath the property type field. Ok now right click there too. This will give you a list of things you can do - you want to build. Click that. This will open up an expression builder...

After literally hours, I'm throwing in the towel on an elegant solution - here's a site with the best answer I have found: http://www.mvps.org/access/forms/frm0048.htm Brambojr

Ok, I now know that the problem is that the control in the subform has focus within the subform, and I need to get it to lose that focus. There are no controls to pass it to, I can use that work around, but would prefer something more elegant. any ideas? I know a few months back before I...

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...

Thanks to both, I think those links will work out for me - it should still work in Outlook 2k. Leslie, I like the signature . . . Not familiar at all with Active X stuff so I kind of stay away from the stuff - at least for now. Thanks to both of ya, I think I have what I need and a little...

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'll assume you have the form set up as well as a drop down box that returns the values you want since both of those items are set up well by the wizards. Create a new query and make sure one of the fields you include is the same as that is contained in the drop down. I'd run it right now...