Search results

I am trying to modify a treeview example (from this site--Treeview 2000). The form's OnLoad event creates a recordset. I would like to use that to capture the PK (AutoNo_Emp) from the selected node, and have it populate an unbound textbox. This is the OnLoad code: Dim otved As...

My DB checks for connection for linked tables when it opens. The two reasons why the connection may be down is due to either the LAN being disconnected or, due to inconsistent mapping of network drives the folders may be listed differently. For example, someone may have T:\Common\Folder\BE...

Many people are interested in managing attachments in Access 2007, but there isn't much info out there. I was able to find a little something on the subject. However, the line of code for exporting (.SaveToFile) will only 'Save As' one attachment in the one record for the form. I added a...

In my db I have three tables: tbl_Employees, tbl_CourseCodes, and tbl_TrainingMain. The tbl_TrainingMain table lists an individual (from tbl_Employees) and a training item (tbl_CourseCodes) and any relevant data, i.e. date completed, remarks, etc. In the tbl_CourseCodes, there's a field...

I have a query w/a calculated filed (TngDue). Some of those records have no date. When I use CDate to convert the TngDue field to a date format, the records w/o date entries give me an #Error. I've tried to use IIf and IsNull to get rid of the #Errors and still maintain a date format, but am...

In my db, I have a button to open a form in 'Add' mode. It's based on a table that has an AutoID as a PK. However, I want to prevent duplicate entries when adding records. I am trying to have it look up the employeeID and the trainingID as a unique identifier on the BeforeUpdate fx. I am...

In the attached database, you can open either the Employee or Course List forms and they both open in the Split View--normal form on top, and datasheet below. I created another form (Training Rip) and copied the command buttons to open the other forms, but when the Training form opens, it opens...

I'm working on a training database. It lists people and course codes, and everything's worked out except for the last--and most important--part. I'm in the middle of designing the main query ("qry_TrainingMain"--pretty original, huh?) and it includes a lot of nested IIf statements. I...

Hello All, I've been away from Access for quite a while, and unfortanely my brain is not wanting to work in Access-mode. What I need the db to do is track all the course codes on each person. As training currently stands, not all the course codes are listed on each person. For example, one...

I've been playing around w/ the Projects Template from Access (2007). One thing I'd like it to do is assign a Task through Outlook based on the info already loaded in the db. The template almost does this in a round-about way. If you open the project form, then the task form, and then...

As a general rule, I use many baby-steps to get to a desired result. Unfortunately, this often makes things over complicated. So, if y'all don't mind, take a look at my example and see if there's a simpler way of getting the end product. With that being said... This db is used to track...

I'm using a browsing function to allow the user to select where previously selected files will be moved to. There are many examples/means to open a dialog box to select files, but I've only been able to find one that selects the folder location. Ghudson's example works great, but I can't seem...

...edit... Wow...I started typing out the problem/question and ended up typing a novel! I can be a bit wordy sometimes.... So, here it goes.:) I'm working on an Access file to use w/ an on-line training record system. The on-line system exports XML files, which I then save & re-name as...

I've been doing a bit of looking around for some DCount/DLookup stuff to help w/ some auto-magic stuff on a new database. After the using enters a new record, I need to check for duplication of criteria. If so, I need to have it capture some info from the form and open a report. The code I...

There are two queries in the database that are used to count and calculate percentages. One (Percentage Query) draws its dates from inputs to a form: >=CDate([Forms]![Request Percent Report Form]![Start Date]) And <DateAdd("d",1,CDate([Forms]![Request Percent Report Form]![End Date])) The...

Like many on this board I've used the mousetrap by GHudson. However, I have two subforms in the main form. This has created a lot of saving. There are three diferent areas to save in now. One thing I did to reduce the number of times a user has to save his/her records is to incorporate a...

Well...here's the deal. Four computers were replaced in our office and now three of them are having problems with the database. The database is written in Access2003 and all computers (the old ones and the four new ones) are running on WindowsXP Professional w/ Office 2003. The problems that...

I've been working on some update utilities which I've figured out pretty well, but I'd like some better error trapping. These utilities are being e-mailed out to the various locations (not connected by a common LAN & not web-based) and I'd like to create a table listing any errors received...

Alright...Our database was benchmarked by several other units. They're completely separate, i.e. independant data collection, no shared networks, different bosses. At any rate, I made some changes to the db and created a "utility update" db for these other units to use to automatically get...

I've run into a problem in my database. It's actually happened several times, but it's basically the same problem. We've been using this database since January and on at least five different occasions a function in the database (be it VBA, query, report, or what-have-you) all of a sudden...