I am working on my website, and I am trying to make it so my menu bar is similar to the one on this website. I was told it requires css, but I am not sure how that works.
Can some provide me with a start, either code, or a very good tutorial website.
Thank you.
UAlbanyMBA
Last Activity: Sep 8 '07, 11:45 PM
Joined: Nov 10 '06
Location:
-
Drop down roll over menu is dreamweaver
-
Such a green mistake. Thanks, and sorry for the hassle. -
Update Error
I am trying to update a record but I keep receiving an error, "Data type mismatch in criteria expression." Here is the code:
It has something to do with the where clause. The code "worked" when I forgot to include it. I need to be able to update a bunch...Code:DoCmd.RunSQL ("Update Caller2 SET Ext = '" & Me!txtExt & "' where CallerID ='" & GlobalCID & "'") -
Oh my goodness. Thank you very much for that one, everything works now. Thank you.Leave a comment:
-
Syntax Error (Missing Operator)
I am getting a syntax error missing operator when I try to created a record set by selecting a record from a list box. I do not know where the error is though. Everything looks good, as a matter of fact I have very similar code elsewhere in my program and it works perfectly. Here is the code...Code:Private Sub lstRequests_Click() Dim dbs As DAO.Database Dim rs5 As DAO.Recordset Set dbs = CurrentDb lstRequests.RowSource
-
Hiding a Column in a search box
In a form I have a list box which displays the results of a search. The results are in 4 columns. The end user doesn't want to see the first column which has the ID number, but it is needed in the recordset in order to do the necessary search by this unique identifier. Is there a way to just hide the first column from sight? I have tried the properties ColumnsHidden and ColumnWidths, but with no luck. Here is the code:
...Code:lstSearchResults.RowSource
-
Thank you both, it works!! I really appreciate it. I don't doubt this will be the last post, but once again thank you.Leave a comment:
-
Ok, here is the code that defines my db and rs as well as the list box.
...Code:Dim dbs As DAO.Database Dim rs As Recordset Dim rs2 As Recordset Dim rs3 As Recordset Dim qdf As DAO.QueryDef Dim strSQL As String Set dbs = CurrentDb lblerror1.Visible = False lblError2.Visible = False If ((FirstName <> "")Leave a comment:
-
You are right to be puzzled, but you are indeed correct. When I open the Form, which main function is to search for clients, The list box only has the header. I then input a first name and last name into there respective boxes and click a "Find Caller" button. This button runs a query to search th db for a match, then lists matches. The user will then select the proper person they are looking for.
Does this help your...Leave a comment:
-
It works!!!!! THANK YOU SO VERY MUCH!!!!!!!!!!! ! :)Leave a comment:
-
Ok, so if I preformed the task correctly the Row Source is: Customer ID;First Name;Last Name;Distributo r. This is because the top row of my list box acts as a header for the list box.
ThanksLeave a comment:
-
The error doesn't come up unless I put up the message. It i just a ZERO or capital "O" not quite sure.
ThanksLeave a comment:
-
Ok, my green nature is showing here, what is it you mean by row source? I thought u were looking for the code:
I'm sorry about that.Code:lstSearchResults.RowSource = "Value List"
Leave a comment:
-
I'm sorry about my poor posting earlier, I didn't mean to form my question that way. When I switch the input mask to Password, I get my self programed error check, a message box popping up saying "invalid username/password"
ThanksLeave a comment:
-
...Code:If ((FirstName <> "") And (LastName <> "")) Then Set rs = dbs.OpenRecordset("Select * FROM Caller WHERE C_F_Name like '" & FirstName & "*' and C_L_Name like '" & LastName & "*'") End If If (((FirstName = "") And (LastName = "")) Or ((FirstName = "") And (LastName <> ""))Leave a comment:
-
Cool.
Is Me a reserved word or should I replace that with my Form name? Because when I put my form name in it, it does not work, but when I leave Me in it kinda works.
It still opens the record to the first John Doe on the list, even if I click, highlight, and select the third one?Leave a comment:
-
Thanks. Unfortunately doing this leads me to the errors I mentioned before. I am also having trouble with my query code, access says it cannot execute my query. Here is my code:
...Code:Private Sub Command6_Click() Dim usr As String txtUsername.SetFocus usr = txtUsername.Text Dim pass As String txtPassword.SetFocus pass = txtPassword.TextLeave a comment:
-
Selecting Data from List Box
In some previous posts I was inquiring about record set order, thanks everyone for the help it fixed the problem. With that step out of the way I am having an problem with the next step.
So I search the DB for John Doe, and I get three results and have them listed in a Listbox:
...Code:ID First Name Last Name 4 John Doe 23 John Doe
-
Masking Passwords
When trying to create a login page in access I am having trouble concealing the password. I have the table setup to accept password as text and masked as "*". In the form I have played around with having the password box show data in real characters or "*". It only works when I have the password box set to text, it provides me with errors if I have the textbox masked to "*"
Any hints?
... -
Ok, I hope this explains what I am doing better.
I have a database filled with clients. When a customer calls the user first must see if the customer exists in the system. This requires the first and last name each in its own respective textbox. The find button first makes sure both fields have data in them, and then creates a record set of all the the fields for any name matching the search criteria. In this case John Doe, where...Leave a comment:
No activity results to display
Leave a comment: