Search results

SO i have a list box that fills based on the following code..... Dim strSQL As String strSQL = "SELECT Products from [Client ProdVend] " & _ "Where Client_Account_Name = '" & Me.Client_Account_Name & "'" Me.List91.RowSource = strSQL Dim strSQL As String strSQL = "SELECT Products from [Client...

Combobox that allows you to select multiply values...... i want it to put the selected values in the combobox into a listbox on the same form....is there a way to do this with vb code.....

i figured it out ...thanks

Well i did this in the before update and its still not working...hmmmm If Me.Combo1.Value = "" Then Me.Undo End If I also tried If Me.Combo1.Value = null Then Me.Undo End If

I add record button. This brings up a form shows a blank record with only one field automatically filled out at the top based on the client on the previous form. However, the problem is, is someone exits this form it saves the record with just that one client field filled out and the rest blank...

I have a listbox on my main form(named:customer editor). I want to be able to double click an item in the list box(name:list91) and bring up another form called productdetails. I want this to bring up the details of teh particular record in selected from the list. so i know in the listbox...

I have a report that shows 3 columns, clients, versions, products and vendors. How can i make it so a user can filter the report to show only certain info. forexample, only show the clients that have a certain product. or only show clients with certain versions. Any suggestions? I want to...

thanks...worked

i have never used a report in access before. I am trying to have all my client information desplay in one report. I want 4 columns in the report. client account name & version from a query/ and products and vendors from a different table not in the query. However some clients are not in the...

it worked..thanks

ok, the new db and importing everythign idea worked.....now i can make an accde file that works....i really hope that fixed the problem with the other versions of excel...it seems weird to me that that would be the problem, but hopefully

Thanks so much for your help, like i said this is one of my first real projects in access so I might be just missing something really obvious. It seems like the code just isnt coming up at all when i check it in the accde. I attached 2 screenshots, maybe looking at that , it will make more...

ok, so i am makeing an assumption, and i dont know if its right or not, but i cant test it since i cant go on a computer with a different version of access at the moment. I assume the problem that its not working when i make accde is the same as y its not working whe i open it in another...

Thanks for the quick response, I really appreciate it. As you can see below, I think it is in the current event like u said Private Sub Form_current() Dim strSQL As String strSQL = "SELECT Products from [Client ProdVend] " & _ "Where Client_Account_Name = '" & Me.Client_Account_Name & "'"...

hey guys, i really hope one of u guys can help me, I'm pretty desperate. I'm by no means an expert in access. other then then occaional class project, I have no experience. A few months back I i started to built a database to hold client information for a internship i worked @. I had gotten...