Search results

Here's a routine which let's you select a folder and will import all the xls files from that folder into the mdb (all you do is select the folder using the Browse button.)

Perhaps this example will be helpful: http://www.dbforums.com/6332819-post68.html I found it's much easier to automatically grab the user's windows loginID via a simple function which can then be utilized anywhere throughout the program - ie. getuser(). You can then simply write code to match...

This is not a hard-fast rule though! In accounting type programs this is often done. In most other types of programs, it's not. For example, summing/averaging/etc... on certain calculated type fields can sometimes become more difficult in the design of the program where it's easier to save the...

Are any of the fields based upon the 'Lookup' tab and then a listbox or combobox in the design view? (where the rowsource of the lookup table is possibly missing) Although this shouldn't cause your problem, it's the only thing I can think of other than the hide. I personally don't like to...

If you don't have the option to make the normalization changes as lagbolt suggested, your other option is to create a field in the table which 'concatenates' 2 or more field values together and make this field unique or a primary key to prevent duplicates. I'll sometimes use this trick as a...

The 1st thing I'd recommend before you proceed is get rid of all the spaces and / in the field/table names. Also as a note, avoid using reserved words for field names and fields named such as: MyFieldName# or other like characters (even though I didn't see any of these characters in your...

I briefly read through the posts and just wanted to add (if it helps) that you can also use the INSTR function combined with the REPLACE. ex: iif(instr(me.fieldname,"/"),.... or iif(instr(me.fieldname," / "),.... or possibly iif(instr(me.fieldname," /"),....etc...etc... Although REPLACE does...

You may have to search for a good backup. I tried running a few of my 'special' repair utilities without success, including trying the /decompile switch, jetutil, and trying to import the tables into a new mdb. I'm guessing somewhere along the lines, the backend mdb became corrupt and you've...

I have several helpful coding 'snippets' you can utilize while building your application located here: http://www.dbforums.com/microsoft-access/1605962-dbforums-code-bank.html There are also a few full applications in the dbforums code bank. You can look here...

For the most secure way to return the users window loginID, see here: http://www.dbforums.com/6274790-post20.html The example also shows you how to setup a security level type system. This method has worked regardless of the environment I've been in whereas other methods don't always work or...

YES! See here if it's non-2007 (it hasn't been tested for MSAccess 2007 but works nicely with previous versions): http://www.dbforums.com/6301669-post51.html Download and look at: 1. FormManipulation2 - Some Cool Button Effects 2. FormManipulation2 - Task Pane Example You'll need to be...

Take a look at the Northwind.mdb that ships with most versions of MSAccess. This has a lot of the things you mentioned. Otherwise, accounting type databases are NOT beginner (or even to some extent, intermediate) level databases, especially if you've never designed one. You can easily get...

You might want to consider the 'getuser' method in this example which returns the loginID of the user. You can then code in (based on the getuser value returned), which form should open. Getuser method: http://www.dbforums.com/6274790-post20.html Ex: If getuser() = "jakes" then...

Simply create a query based off of any data table and then change the query type from a Select query to a Make-table query (you'll get prompted for the tablename to create when you change it to a make table query). Execute it and then look at the table created.

I personally would avoid any code (or macro) which updates a date/time/status recordset on the form's loading or opening event. I've only done this in rare situations and did it sparingly. Instead consider something as triggering the event to update off of an event such as an OnClick event of a...

Here's some helpful tips on how to maximize your opening speed of forms. http://www.dbforums.com/6356210-post76.html and http://www.dbforums.com/6366815-post77.html In regards to DAO versus ADO, I've seen this topic come up often. Here's comments from someone who has extensively used both...

To avoid locks with multiple users in the same frontend mdb/mde, you can use this script here which works very well and will prevent (*.ldb locks). You can have 100's of users. http://www.dbforums.com/6274786-post19.html I guarantee you'll never have to search down users again to see who has...

Avoid MSAccess Replication at all costs (whether it be frontend or backend). I worked with MSAccess replication for several years and it's nothing but headaches. An external user connecting will eventually cause some problem or another, mainly due to the relationshipships MSAccess tries to...

You may want to try deleting/re-linking (or refreshing) the linked tables in each of the front-ends. Sometimes a table design change causes issues where if one user's frontend doesn't have their tables refreshed with the new design changes (ie. a new field was added/deleted in the table itself)...

Here's the link to the actual cloning script: http://www.dbforums.com/showpost.php?p=6274786&postcount=19 Here's the benefits of having your users get into your mdb via vb script (text below copied from my post on www.dbforums.com code bank): Try this method out! Are you tired of having to...