Search results for query: *

I have been working with the "After Update" Event Procedure on a particular control. I've got it worked out to where my "IF" statements are doing what I need them to do, with one exception...the one where I want to BackGround to change color, doesn't. Here is my code: Private Sub...

I have two databases where there is redundant information. In other words, instead of just creating new/additional fields, the user created a new database with a table containing several fields from the previous Main table, and the new 'additional' fields. Since the tables contain many of...

This post relates to my previous post (thread702-1148781) where I needed to cause an 'option group' to return a YES or NO response depending on what value was selected in a combo box. I figured it out with the help of Xiciana, but now I've realized that this combo box should also trigger...

I'm taking the advice of the many experts in this forum, and I'm weaning myself off of using MACROS. So, I searched the FAQ's on this forum for a way to 'code' the command buttons to search various fields. I found the following example: Dim rst As Recordset Dim strSearchName As String...

I posted this in the "Access Forms" forum, with no luck. I figure that since this is probably going to take a SELECT statment or VB code, that I would try here. Here is where I'm at: I have a combo box that is based on a table (tbl DACS Country Code Table) for the 'selectable' values. This...

I have a combo box that is based on a table (tbl DACS Country Code Table) for the 'selectable' values. This table contains all of the possible country codes that we use in our office. We also must distinguish between "Special Interest Region" countries and "Non-Special Interest Region"...

I have received a request from one of my 'endusers' of my Access application; they want to be able to scroll up and down in the PROSLOG number (primary key, indexed). I built a macro that contains two events; GoToRecord - Previous, and GoToRecord - Next. I assigned these to the "On Key Down"...

I'm trying to update a new field (option group generated) from a "check box" field. I thought that an SQL statement would work best, but I'm not that good at building one from scratch. The following is my attempt at it: Table name = 2005 LOG New field name (option group) = TempFileUsed Old...

I tried searching this forum for information on having the focus go back to the first 'control' textbox of the tab order, but I couldn't find anything that quite addressed this problem. What I need is this: to be able to open up my form, have the focus on my PRSLOG number, then if I hit the...

I am having a problem where every time I try to paste the records from the previous day (about 20) I get the 'paste error' prompt. I end up clicking the OK button until it processes through, but then because of these errors Access will put the 'appended' records in a 'Paste Errors' table. When...

This is kind of a two-parter: First, I need to prevent the users from entering duplicate numbers (office generated) into a particular field. These will always be unique in this table. For now, I have to let them have access to the table, but this is only temporary. I am weaning them from...

I have been trying to develop an "Append" query that will pull the data from one table across the network and append it to the database that I'm currently working in. Sounds simple, but I only want the newly created records that aren't currently in this database -- not the whole table. As it...

I have a database where the users are manually inputting the next "PRSLOG" number. They end up going to the last record, adding one number to it, and then putting it in the field. They would like me to 'automate' this so that every time they click the "add new record" button it automatically...

I am building an Access 2000 application with a 'tabbed' form (GUI). The first tab is labeled 'Quick Look', the second 'General Info', the third 'Arrest Info', and the fourth 'OR Info'. It is slowly coming together, but the curiosity of the users on the floor have prompted them to put in...

I'm working with a database where the users are inputting new records throughout the day. I am actually working on a copy, but I would like to put a command button on my form that I could use that will 'update' the database from the 'live' database without having to go back to the database...

This thread relates directly to my previous thread, but maybe I was being too vague. I am using a listbox to display the results of a query that is run when the 'tabbed' form is first opened. What I want to do is to be able to 'requery' or 'update' the results of the display of results, after a...

I am building an Access 2000 application using the 'Tabbed Form' style of form. First, a little history; currently, the users have been entering and searching in the raw table itself. This practice has gone on for years. After taking hours to piece together data for the 'higher ups' in our...

Right now I am using check boxes for a few fields. I am building a form that will have these fields (check boxes) for the data entry. I don't want more than one of these check boxes 'checked' at a time. In other words, they will be given these check boxes as choices, and I don't want them to...

I have tried to find an example in the 'help' portion of Micorosoft Access, but I couldn't find anything. I think that I am looking for a "standard" module that will be triggered from a 'timed' event that will automatically close the database after a specified amount of idle time. If this...

I need to be able to set my database to close (and save) after a specific amount of idle time. Is there a way to do this?