Search results

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

Here in lies more questions, like which is the correct record? How do you make the determination as to which one is the current address, why is it in multiple tables, and would you want to keep the records that appear in each table? Wouldnt you want to delete one entire set of records so that...

Make a find duplicates query by clicking the NEW button within the query area. Creat one that looks at zip and it should return each unique zip with a count of its reoccurance.

There are several ways of going about this. I personally would use (seperate) queries with the criteria of IS NOT NULL for the second and third charge field. Doing this would seperate only those records that have something within these fields. Once you develope a way to filter them out, deleting...