lee weaver
Last Activity: Nov 19 '10, 07:08 PM
Joined: Aug 6 '08
Location:
-
Thank you so much!! I have been beating my head on my desk all morning. Microsoft error messages are so helpfull when debugging GRR -
something resetting status of select case or multi-line if statements
I have an odd situtation where a section of code is resetting the status of either multi line If statments which then gives me the error " end if without block if" or something very similure, or select case where it's giving me " Case without Select case"
here is the offfending code.
...Code:Private Sub loginbutton_Click() Dim rs As Recordset Dim db As Database Set db = CurrentDb Dim searchstr
-
lee weaver replied to Form will only display data if the form property "Record set type" is set to Snapshotin AccessLinq:
Thanks for the quick turtorial on those properties. I have 3 count them 3 books here on VBA and access not 1 addresses this....Leave a comment:
-
lee weaver replied to Form will only display data if the form property "Record set type" is set to Snapshotin AccessI am attempting to do away with the other field as we speak. It was a way I came up with getting around my lack of knowledge about multi column list boxes. but is has been working well for me. not sure why it wsan't working for you. it's going to take a bit of rework now to get the 2 fields that I have 1 in this table and 1 in the containers field removed and teh code adjusted but it's teh right thing to do. thanks again for the help....Leave a comment:
-
lee weaver replied to Form will only display data if the form property "Record set type" is set to Snapshotin AccessYou my friend are a genius. Thank you so Very much.
How counter intuitive is that? I figured, I need to be able to enter information so i need that to yes. Wow thanks again Microsoft.Leave a comment:
-
lee weaver replied to Form will only display data if the form property "Record set type" is set to Snapshotin AccessData Entry -- Yes
Allow Additions -- Yes
Allow Deletions -- No
Allow Edits -- Yes...Leave a comment:
-
lee weaver replied to Form will only display data if the form property "Record set type" is set to Snapshotin AccessYour observation completely eliminated teh largest section of code. Here is the remaining code. but the problem remains.
...Code:Option Compare Database Private Sub First_name_Exit(Cancel As Integer) popfullname End Sub Private Sub popfullname() Me.[Full name].value = Me.Last_Name.value & ", " & Me.First_name.value End Sub Private Sub Form_BeforeInsert(Cancel
Leave a comment:
-
lee weaver replied to Form will only display data if the form property "Record set type" is set to Snapshotin AccessAt first I was thinking that I would need all of this code. But after thinking this over, there is a large section I do not ned. will make apporate changes. but I'm almost certain this isn't causing my issue. but one never knows until one trys.
Thanks for the input....Leave a comment:
-
lee weaver replied to Form will only display data if the form property "Record set type" is set to Snapshotin AccessThere is a sub form that is also not displaying corectly that is based on another table.
But that works fine in the Add employee routine. all i did for this edit form was add this list box at the top to select the employee's record to edit.Leave a comment:
-
lee weaver replied to Form will only display data if the form property "Record set type" is set to Snapshotin AccessIt's only based on the "Staff" TableLeave a comment:
-
lee weaver replied to Form will only display data if the form property "Record set type" is set to Snapshotin AccessI just tried Changing to Dim rs As Recordset with no luck. Same results. No data is populated if recordset type property in the form properties is set to anything but Snapshot.Leave a comment:
-
lee weaver replied to Form will only display data if the form property "Record set type" is set to Snapshotin AccessThe Dim rs as Object came from acccess when I created the list box with the wizard and told it to select the record in the table based on the selection made. It's auto generated code. the record set is as follows.
ID - AutoNumber
LastName - Text
FirstName - Text
Organization - Text
Work Phone - Text
Home phone - Text
Full name - Text
Active - Yes/NoLeave a comment:
-
lee weaver started a topic Form will only display data if the form property "Record set type" is set to Snapshotin AccessForm will only display data if the form property "Record set type" is set to Snapshot
I have a form to edit employee data that is a copy of the add employee form ( Which works great) with a list box at the top to select the employee to edit that is susposed to navigate to the correct record.
I am using the list box wizard to create the listbox and select the record. The problem is that it only works if i set the form to snapshot so I then can not edit the data.
It will navigate correctly and display... -
Thanks for the Information
Thanks for the Information, but apparently i posted in the incorrect area. I need information on VBA not VB6
Thanks again.
Wanders off to ask Google.Leave a comment:
-
lee weaver started a topic Adding mutiple records to a table when adding a new record to another tablein Visual BasicAdding mutiple records to a table when adding a new record to another table
I have a table for employees and a table that shows which containers they have access to and a table of all containers.
What i need to do is when adding a new employee i need to add a record to the "access" table for each record in the container table. that would basically default the new employee's access to each container.
I think the following code in my addemployee form_Load event should detect if they... -
I am trying to implement this code also
on this linei'm getting the error User defined type not defined.Code:Function HashString(ByVal Str As String, Optional ByVal Algorithm As HashAlgorithm = MD5) As String
I copied the entire code block at the top and placed it in it's own module.Leave a comment:
-
I don't have a control or a varable named container. I have a field in a table named container. should I chage that?Leave a comment:
-
No luck with trying the string approch.
No luck with trying the string approch. I'm going to start over on this form from scratch see if i can maybe come up with a completely diferent way to attack this. I will post bak if i come to a resolution.Leave a comment:
-
It's a field in a table.
Container is a numeric field in the table Containers, which is the table that this form is bound to.
Like I said before I used almost the same code to deal with a diferent table for deactivating employees, and it works flawlessly. but those were text fields, and teh list box was only a sinfle column instead of a multi compuln one like here.
For perspective here it the other code...Leave a comment:
-
incase it helps since teh project is so small i'm posting the entire code for the whole form.
...Code:Private l6 As String ' value of List6 selection Option Compare Database Private Sub List6_Click() Updatebutton End Sub Private Sub List6_Exit(Cancel As Integer) End Sub Private Sub Command6_Click() On Error GoTo Err_Command6_Click
Leave a comment:
No activity results to display
Leave a comment: