Search results for query: *

Hi, I want a button to add 10 records with a value of "none" to a table called ICL 1. Here's the table structure: Item ID (Autonumber) ICL 1 (Text) I want the ICL 1 Field to be populated with 10 records that have a value of "none." Is this possible? Thanks! ---- Alex Anytime things...

Hi, In the Forms OnOpen Event, I want a textbox (txtICL) to go to the Last record that is not "None". How would I go about doing this? Thanks a bunch! ---- Alex Anytime things appear to be going better, you have overlooked something.

Hi, I want to filter a text box not to display the word "none" if there is such record present. I also want to filter out Null Records. In combo box, I do it this way: SELECT [ICL 1].[ICL 1], [ICL 1].ItemID2 FROM [ICL 1] WHERE [ICL 1] Is Not Null And [ICL 1]<>"None"; How do you do it with a...

Hi, I have a form that has a textbox in it that serves as a counter. When a certain number is shown in the counter, I want go to Next Record in another form that is open as a pop-up. I am using the following code: If Form_ICL41.Text2.Value = 3 Or 5 Or 7 Or 9 Or 11 Or 13 Or 15 Or 17 Or 19 Or...

Hi, I have a database that contains test items. These items are then grouped by classification. Here is a sample of the classifications: Level 1: Math Level 2: Addition Level 3: Simple, Hard Level 2: Division Level 3: Simple, Hard I want to create a form...

Hi, I need to have a command button that adds the word "None" into the ICL field in a table. Here's the table structure: Item ID (1-12000) ICL (Text) For Item IDs 1-100, I want the button to add the word "None" to the ICL Field Name that corresponds to those Item IDs Is this possible...

Hi, I have a report which contains a hyperlink that displays a link to a certain image on the user's computer. When the report opens, is it possible for that hyperlink to be replaced by the actual image that it is linking? Thanks, Alex ---- Alex Anytime things appear to be going better...

Hi, When the search box pops up, its default setting is to match the "Whole Field." How can I change so the default setting is "Any Part of Field"? Thanks, Alex

Hi, I have the following tables in my database: ItemsTable Item ID Item Text .... .... GeneralInfoTable Item ID Item Key Item Author .... .... CaseTable Item ID Case Text .... GraphicTable Item ID Graphic .... If the user has all of the data stored in an Ascii file, how could I create...

Hi, I have items in the database that all have Item Texts and unique Item IDs. On a form, I want the user to be able to type in the Item IDs into a single Text Box, (ex. "1, 2, 3") and for the Item Texts of those Items to all be copied to one Text Box. Is this possible? Thanks, Alex

Hi, I have two text boxes on a form. They are linked to two separate tables. Table 1 (Linked to Text Box 1) Item ID 1(Autonumber) ICL 1 (Text) Table 2 (Linked to Text Box 2) Item ID 2 (Autonumber) ICL 2 (Text) Table 3 (Links Table 1 and Table 2) Item ID 1 (Autonumber) Item ID 2...

Hi, I want to export a hyperlink to word. Everything works, it exports the hyperlink to word, but when it is in word, it is no longer a hyperlink (no longer underlined), its just text. It looks like this: "C:\Image\Image1.jpg". How could I make it that it transfers the hyperlink while keeping...

Hi, I have an "Add Graphic" form which lets the user find the image they need using a hyperlink. I also want the hyperlinked image to be displayed in an Image Box. I use the following code: Me![Image].Picture=Me![Hyperlink] This code is put in the forms OnCurrent Event. The problem is that...

Hi, I have a code that is linked to a module.... On the onOpen Event of a form, I want the code to be executed every five days or to have it be executed every fifth time the form starts. How could this be done? Thanks, Alex

Hi, This question has probably been asked before, but I couldn't find a forum here that deals with this subject. My question is....how can I code a text box that displays the current date? Thanks, Alex

Hi, I have a module that copies a file from one directory to another directory. How could the program check to see if that file already exists in the directory that the file is being copied to? Thanks, Alex

Hi, I have an access database (I know that this is a VB forum, but this concerns VB) that allows the user to back up their data. I have a backup.bat file with the following code: copy Database.mdb C:\Backup /y This is what I have in mind: I want the user to click a command button "Back Up...

Hi, This is probably a very simple question that I haven't found an answer to... I have a backup.bat file that backs up the back-end of the Access program. I want the user to click a button that runs the backup.bat that backs up the back-end of the program. How is this done? Another problem...

Hi, On the main switchboard I have a command button "Back Up Database" that has the following OnClick code: Macro2 Code for Macro2 RunApp C:/backup.bat Backup.bat was created in Notepad and has the following text: copy Database.mdb C:\Backup /y When the user clicks "Back Up Database" I...

Hi, I created an item database manager program using access. From time to time I will be releasing updates for it. I was wondering if their was any way to update it from the program. From the Switchboard, I want the user to click a command button "Check for Update" and for the program to...