Search results

Hi, The user wants all of the records in the database to have continuous numbering. I have used AutoNumber in the past but if you delete a record, it produces gaps in the numbering. I was wondering if there is a way to number the records so they are always numbered continuously (1,2,3,etc.)...

Hi, When I add items to a report, it truncates the last 1 or 2 words of one field. The field's properties are set to Can Grow=Yes, Can Shrink=Yes. What might be causing this problem? Thanks

Hi, I have an mdb database that is protected through a password. I have another mdb database (which is the one that the user opens) that opens the first protected database. So the user cannot access the 1st database without a password. I am wondering if this is enough protection or do I have to...

Hi, I use the following code to add items to a report from a list box: Private Sub Command20_Click() Dim rsTempTable As DAO.Recordset Dim intLoop As Integer Dim msg As Integer msg = MsgBox("Do you want to save the current test for later use?", vbYesNo) Select...

Hi, I get the following error message and it highlights the following code when I use this module: Option Compare Database Option Explicit Private Declare Function apiShowWindow Lib "user32" _ Alias "ShowWindow" (ByVal hwnd As Long, _ ByVal nCmdShow As Long) As Long Function...

Hi, I have a form that has a textbox that shows a date in the form of 1/19/2005. I want, when the form opens, to add a certain number of days to it. For example, say I want to add 9 days to it, when the form opens, I want the textbox to read 1/28/2005 instead of 1/19/2005. So I want to do...

Hi, BACKGROUND I have a back-end database (database_be.mdb) in a folder (C:\Access). GOAL I want the user to be able to enter the name of the new back-end that they want to create. Then, when the user clicks a button, the program will create a copy of "database_be.mdb" but change the...

Hi, I have a front-end and a back-end database. I set a database password in the back-end. However, everytime I open the front-end database which is linked to the back-end, I get a message that says something along the lines of "the password is invalid." It didn't even prompt me for a password...

Hi, When I export an item from access to word, this is how it looks like: 1. What is the angle in this picture? C:\Pictures\Angle.jpg A. 120 Degrees B. 90 Degrees C. 180 Degrees D. 150 Degrees I was wondering how I can replace C:\Pictures\Angle.jpg with the picture that it points to?

Hi, How can I create a toolbar in access that would, when pressed, copy the text of the current word document (note: the word document is not saved) to a text box on a form in access? Thank you

Hi, I have a combo box on a form that lists Item Classifications: Math Science Writing I want to be able to select, say math, and be able to edit it and then save the changes. Here's the row source of the combo box: SELECT DISTINCT [tblICL 1].[ICL 1], [tblICL 1].ItemID2 FROM [tblICL 1]...

Hi, Here's in essence what I want to do: Say I have a text box with the following values in it: NOTE: These values are item classifications Math Science Math Reading Writing Science Math Math Writing I want to compute how many total Math Values there are, how many total Science Values...

Hi, How can I change the criteria of a query? For example, I have a Query called qryQuery1. It has the following fields: Item ID Item Author Item Question Item Classification I want the user to have the ability to limit the items by, say, Item Author and Item Classification so I would like to...

Hi, I have a form which has a listbox that lists all Item ID's currently in the database. The ListBox's Multi-Select is set to Simple. Lets say the user chooses the following Item IDs: 3, 258, and 396. After the user clicks a command button, I want the program to find the records that have...

Hi, I have a folder "C:\Databases" and I have the following files in it: db1.mdb, db2.mdb, db3.mdb, and db4.mdb. I want to copy these files into a folder "C:\Databases2" with a click of a command button. How can this be done? Thank you!

Hi, I have a list box that displays values from a field in a table. I was wondering how I can make the list box scroll to the very bottom of the list automatically so the user can see the latest values that they have entered? Thank you!

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 created a form where...

Hi, In the Forms OnOpen Event, I want a textbox (txtICL) to display the last record that is not "None". How would I go about doing this? Thanks a lot!

Hi, I have a MultiSelect list box on a form that contains all of the Item IDs in the database. When the user clicks on an Item ID, is it possible for the item that has that Item ID to be displayed? Thanks, Alex

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