Search results

I have been looking around quite a bit to see if I could find an easy answer (its never easy), but have had no luck. I have an Access system that runs fine in Access2K, but all I get are reference errors in 2K2. Is there a simplistic way to get these refrences to register? Would creating a form...

Here is a very small example of what I was stating. You will notice that only the data related to the individual displayed in the main form will show in the subform. With further tweaking we could get the subform to be filtered by date and such.

I think you misunderstand. If you create a form that displays a single user at a time, and put a drop down menu on it for quick record selection - you have about what you developed so far. Now, you should have the user data in one table and thier time records in another table - with a 1 to many...

How about creating a subform for the actual data entry, and leave it in spreadsheet view. If you base it off of a query, you could allow them to filter it down to just the dates you need. Put all of the employee info on the main form, and let them use a drop down to select whom they want. Just...

You are semi right You can implement the proper connections with the Front Page software (or whichever app you choose), and your data will be stored within the database. You can run ASP type form generation, or simply create a front end access mde/mdb to the database that will allow you to...

There are too many varibles in such a setup, and they all depend on what you have and where it works from. Here is a quick snippet straight from the help files of DW. I suggest you brose the F1 repository to see what it has in lines to match your needs. To create a database connection in...

There are too many varibles in such a setup, and they all depend on what you have and where it works from. Here is a quick snippet straight from the help files of DW. I suggest you brose the F1 repository to see what it has in lines to match your needs. To create a database connection in...

Straightfrom the help files of DW. To create a database connection in Dreamweaver: -Open any ASP page in Dreamweaver and then open the Databases panel (Window > Databases). -Click the Plus (+) button on the panel and select Data Source Name (DSN) from the pop-up menu. -The Data Source Name...

Just a suggestion, but I would much rather build the HTML interface in either Front Page or (better yet) Dream Weaver, and then use it to link/display the data from your access database. Both integrate very well with access, and also allow you the restrictive/selective control you are looking for.

Iwould use VBA to accomplish something such as this. First you would have to create a loop to build a variable that would hold all of the names. I recall along time ago in one of the classes I took an example of just such a thing. The loop ran adding to that value of the variable the e-mail...

Why use access for the interface at all??? I would personally use something like FrontPage or better yet Dream Weaver to create the html interface, and then link it to the database. You can generate as many forms, reports, queries and such that way and have a very snazzy interface for them to...

Been awhile since I have been in the forums, but I was hoping to receive some enlightenment on a problem. I have a system that requires some simple data filtering/cleaning before it goes to processing. I have created 3 queries (the ones starting with ~) and need to have these fire in thier...

Well, I have not found an easy way to intergrate the PDF INTO Access, however with Adobe 6.0 pro full, you can impliment ADBC. This is similiar to the ODBC use within Access, and will alow you to use access data to create completed forms in PDF file format. You need the full version for it to...

Is this an internal e-mail useing something in the way of outlook? Do you have the e-mail addresses within the database? If you are familliar with VBA, you can 1) Create a report detailing what you need (based off the proer queries and such) 2) Create a button to trigger the e-mail and code...

Glad you got if figured out. What you were looking for is called a concatenated key.

Did you use an input mask for the field? What type of format is it in? If you left it as a text file, then you could run a query against it and create a code to seperate the 3 sections of the data by the /, then run a check against them, correct the wrong ones, then reassemble then into the...

Have you tried to do a refresh or recalculation on the ON CHANGE or ON EXIT properties of the text boxesa? If someone were to make a change, then the code would be triggered to refresh.

Sorry, For some reason I was unsubscribed to the thread. I appreciate the info Ian and I will look into it. I actually used Adobe Acorbat 6 Full feature of ADBC which works very well with Access. It links the forms to the datasource and then will "Spawn" one competed form for every record in...

You have way too many tables. You said you had 24 tables containing similiar fields. These should all be in one table, and add a field for the state to identify which state they are in OR create a seperate table with ALL states listed and you can use a lookup field to refrence that table. Then...

The problem goes back to the structure of the database itself. As Pat stated, "Union queries do not produce updatable recordsets". What I would do at this point (just to get the printing done) - use the union query to create a tbl containing all of the data. Use queries to eliminate all unwanted...