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

I have a front-end database protected with a password. I also have a back-end database to it which is not protected by a password. Then I have another regular database (not split into FE & BE) which just launches the first front-end database and enters the password for the user. So the user...

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

Could you point me to an example of where I can find how to exactly accomplish what you have mentioned? Thank you

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

Here you go. Found it here: http://www.utteraccess.com/forums/access/access983668.html Good luck, Alex

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

Thank you very much! That got the job done!

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

I have found what I was looking for! CyberLynx on dBforums provided a great example of exactly what I was looking for. Check out the attachment. Thank you all for helping as I learned a lot! :) Thank you

Math Science Math Reading Writing Science Math Math Writing These are classifications for items. This is so the user knows whether the item they are looking at is a Math Item, a Science Item, etc.... This goes to show that the user has selected 4 math items, 2 science items, 2 writing items...

So what are your suggestions about what I should do? I need to somehow have a count of the item classifications. Can I have the item classification be added to a string when the item is intially added to the test and then have some kind of check such as this: If txtItemClassification = StrCheck...

That is the way I learned how to do it. If there is a better way, please tell me. Is there an easier way that would make counting easier? Thank you

So you are saying that I cannot count the values in a text box? Would I have to create a table and store these values there? If the following is one record: Math Science Math Reading Writing Science Math Math Writing Could I accomplish this: Math (4) Science (2) Reading (1) Writing (2)...