Good Afternoon! I have created a database in access 2007 with several forms. I set the navigation pane to not display, and a form to open on startup. I know that if you hit the shift key while opening the database it will display the database objects.
What I am trying to do is make it so that if a user holds the shift key (so they can see/manipulate database objects) it prompts for a password first. Then if they don't have the...
rnashting
Last Activity: Sep 23 '10, 06:05 PM
Joined: Mar 3 '10
Location:
-
How to password protect tables
-
Thanks again! I'm not in the office until tuesday, but I'm going to try to use this for a delete form too. We never learned a thing about the Form_BeforeUpda te event. Now that school is over I'm finding out how many things I wish they had taught us...
Thanks again! -
Thanks for all of the answers! Sorry for the long reply time ( I try to reply Jerry...I feel your pain), we had a family tragedy that required an extended leave of absence. As to the solutions above, I think that the reason us newbies go right to code instead of bounds is that alot of us find sights like this while in school or training, and schools only teach what the course teaches. I never heard of a recordset once while in VBA/Access class!...Leave a comment:
-
How to delete a record using an unbound form
Good Day everyone! Here's what I'm trying to do in a nutshell. I have a table that I want to allow people to manipulate via forms. I'm using unbound forms because I don't want users to be able to add/delete/edit fields without validations. For my delete form, I want to use a combo box that loads up all of the items in column 1 (serial#) during the form load event. The user will pick an item and use a command button called "find record".... -
Plus, if they hit the back arrow it shows current records also...Leave a comment:
-
That is much easier, but what concerns me is that all it takes for a new record to be added is the TAB button. Is there a way to disable that, and make them push a command button to enter the record?Leave a comment:
-
Populating a table using a form
Good Morning!
I have created a form as well as a table, and would like to use the form to populate the table. I did not base the form off of the table, because I do not want the form to display any of the records from the table. The end goal is to give folks with very little computer literacy the ability to fill out a simple form and click a command button to add items to their inventory.
That being said, I am unsure... -
Woot!
Thanks ADezii! I would be super interested in seeing that. I think I'm on pace to do my own thing for now, but seeing yours can show me things I'm sure that I don't know that I don't know.
BTW...I've tried many sites for programming advice and help, and this one is definitely the best community around. Hopefully someday in the not too distant future I can have enough knowledge to start helping instead of needing...Leave a comment:
-
That looks good. The only thing that looks weird is that I don't see a declaration for the intRowToGet, but I'll plug that in also and play with it. Hopefully this gets me rolling. Thanks!Leave a comment:
-
Hm. I'm thinking that a recordset is the way to go, but this is getting a little bit above my skill level. Here's what I've done:
1 - Created a table with 3 fields (ID, question, answer)
2 - Created a form with a command button to start the quiz
The code I have so far is:
...Code:Option Compare Database Option Explicit Dim localConnection As ADODB.Connection Public Sub Form_Load()
Leave a comment:
-
Loading tables into arrays
Hello everyone! I am trying to create a quiz program, and am having a mental block. I've made a form, and want the cmdBegin_click( ) function to call another function called loadtrivia(). The loadtrivia function is going to take 3 fields from a table (question#/question/answer), randomize them and use an input box to ask the question and accept the answer. The thing is...I'm not sure how to load the table. I'm thinking an array, but the syntax... -
Remote connection 3709 Error
Hello again everyone! I'm having an error trying to retrieve things into a form from a database. I'm just learning, so I'm using the Northwind template that access has, but I'm getting an error that I can't figure out. I let the connection establish during the form_load event, and I get a msgbox confirmation that the connection is established, but when I try to retrieve fields I get "There was an error retrieving information from the database.... -
Thank you so much! The book we are using is very vague...and as you can see, I'm still not very good at this. I didn't even realize that the number in the write was a field, I assumed it was a place holder. Concerning your With block, can I set those things within the form design or do I have to write the code? I had set those things when building the form, and it seems to work, I'm just curious as to why you coded it instead.
Thanks...Leave a comment:
-
using .dat
I'm still learning to program, and the book I'm using is teaching about .dat files now. You're right that it doesn't seem like the best way, but I don't want to discount it without knowing what I'm discounting :)Leave a comment:
-
Reading information from .dat files
I am trying to create a form that writes a .dat file, and then another form that reads the file and outputs the fields into a list box. The creation seems to have gone fine, but reading the file seems to not work so much. Can anyone tell me what I'm doing wrong? Here's what I have so far:
...Code:Private Sub cmdCreate_Click() Open "c:\users\brian\Documents\School\CPT 323\friends.dat" For Output As #1 Write -
Thanks!
Thanks for your help! I'm still not sure I grasp the calling of the arguments concept, but I see how the code you gave me works, and I'm going to try it with a few different examples to gain practice!
TJLeave a comment:
-
Argument not Optional
Good Morning! I am still very new to VBA, and I'm getting an error that I can't figure out with a basic code. Here's what I have at this point:
Option Compare Database
Option Explicit
Private Sub cmdLarger_Click ()
FindLargestNumb er
End Sub
Public Function FindLargestNumb er(ByVal Number1 As Double, ByVal Number2 As Double)
Number1 = Val(txtOne.Valu e)
Number2...
No activity results to display
Leave a comment: