Recent content by durexlw

Imagine a company: There are certain tasks that need to be done. Each task consists of a certain step. For example: task = "requestion vacation" Steps involved: 1) filling in a form 1.1) parameter 1 = points to the correct form for this step/task 2) having this request approved or denied 2.1)...

Imagine functions (as in coding): there is a function call, to each function there are parameters and whereas the names and the amount of parameters is specific to a function, the value of that parameters is specific to each individual function call. For example: Add (Number1,Number2) ADD =...

I'm asked to do a specific task, a database concerning of: Tables: 25 Forms: 25 Reports: 40-45 Build from ground up, multi-user, accounts, account-restrictions, has to be linked to an already existing database, will need a fair amount of VBA coding. I would like to know specifically two...

This basically handles itself... What you can do is open the tbl_linktblpr table in table design, Select the product No. field, and change it's Data type to a Lookup Wizard. When you finished the wizard, just open your tbl_Transactions table, create a form and you'll see a subform to link...

I didn't know this was possible. Can you post a few words or links about how this works? I made a project a few days ago, where I had to parse XML files, if you need some help with parsing XML, just ask.

If for each XLS file, you need to extract the same data, then the answer to your question was pretty much already written in front of your nose. In fact there are many ways... an easy one: build your database first, forget about visual studio, get yourself a beginners course on access...

I feel uncertain to what your question is exactly. Do I understand correctly that you have a table with client information (like their name and email) and that you have in that table, linked to each client a directory, where each directory contains files you would like to attach to your email...

Thanks gemma-the-husky and WayneRyan... I couldn't have asked for more. What you said gemma, is usefull indeed, however, I did this and when I imported the three new tables, they seemed to have lost their relationship (when I looked it table relationships, all relations between the imported...

You know the scenario where people keep working in an old version of a database, while you work on an update... leaving you with a new database, but old data? This concerns a database, containing about 20-25 tables all linked together. I was asked to make an update. In this update 3 new tables...

I was looking for some code add-ins today, here's a few links I ran across: http://www.softwareaddins.com/CodeWiz11.htm http://www.code-vb.com/code_vba.htm http://www.mztools.com/index.aspx The last two are free, I'm unsure about the first one.

Isn't it so that if you specify on your table properties you only want two decimals, it get's rounded automatically. As said in the initial post, formatting only handles how it appears, but specifying the number of decimals in your table properties should fix that too if you ask me.

I'm unsure about what your question is. A good example is the Northwind database that comes with Access. It has all you'll need to know for pretty much anything you'd like to make. If you question is a more specific example that relates to your problem, I have never came across something like...

Rafael, You can do this with access pretty easily. If I get it right, you'll need a single table that has an attachment field and some other fields if you want to keep extra data. Drop that on a form and access will handle the search and navigation parts. ...However, if I get you right, you...

By the way, if you're on Access2007, check out the new feature: TempVars It's a collection that lives as long as your DB is open, across forms and whatever... simple to use: To store a value: TempVars.Add "CustomerId", Me.CustomerId To get it back: sTemp = TempVars![CustomerId] In the...

What you did is a good example of making yourself work for your PC... Just write some code that operates on this idea and save yourself a headache: |-----------| | Testtable | |-----------| | ID | | Counter | | Year | |-----------| Counter is a number Year is a date ID is a...