Search results

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

I know office 2007 has an option to do a mailmerge automatic: Open your table/query. Then under External Data --> More --> Merge it With Microsoft Word. It allows you to open existing document or create new ones on the fly and store your settings afterwards. I never used it in VBA, but you...

Also, look at this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=144978

Another option is to use the openargs of the openform command. I remember doing that somewhere in the past. If you need to pass multiple parameters, write a little parser for it. Here's a guy who typed it out for me: http://www.codeproject.com/KB/vb/passvaluetoaccessform.aspx

When you said the above, Neil, I felt relief because it allowed me to see that trying to normalize this is not functional. Thanks for the directions. That's all I need. Thank you for confirming this. I feel appreciation for the way you responded in short and specific ways because it made me...

Office Button --> Access Options --> Current Database --> Display form (the first combobox from the top) Keep in mind Access 2007 doesn't have a switchboard as you're used to in 2k. The alternative is far better, imho. Look the included DB's to see examples.