Recent content by brighteyes

have you tried importing an .xls from the file menu? You have the option of importing into a new table or an existing table.

Here’s a little scenario: An engineer requests that “x” amount of computers are ordered for the company. The estimated costs of the system(s) are determined. The estimated cost of the systems is forwarded to a manager, and the request must be approved by a manager before the order is placed...

I have a form with a listbox that is populated with data from a query. There are 6 columns of data. Under properties it is possible to set a width that will apply to all columns, butt is it possible to set the width for each column? Thanks

ok ive got to go to a meeting... Ill be back in an hour to try to figure this out again. thanks for your help and suggestions... im getting close, but im still not there. :)

Thank you, I think I am getting closer now. Now I am getting the message "Runtime error 2427... You entered an expression that has no value." ??? If Me.optXonACabinet = 1 Then Me.lstXonACabinet.Visible = True Else Me.lstCheckedOut.Visible = True End If I know my syntax is probably wrong...

Private Sub chkXonACabinet_Click() If Me.chkXonACabinet = 1 Then Me.lstXonACabinet.IsVisible Else Me.lstCheckedOut.IsVisible End If End Sub This is driving me nutts!! :)

I am still getting the "invalid Property" when using a checkbox. I am beginning to think there may be some configuration problems with access 2003...........

hmm. Thank you for the suggestion. Im not sure what the purpose of frames are, but I will try it out. the code is good though?

I have a form with an option button called optInTheCabinet and a list box called lstInTheCabinet. When ever optInTheCabinet is clicked, I want lstInTheCabinet visible. The value of optInTheCabinet = 1, and the visible property is set to "No." I am getting the error message "Invalid Use of...

I've got a DB with this table, Systems. Ive got this form that has 2 option buttons; optCheckIn and optCheckOut. It also has a listbox called lstComputers. Depending on which option is selected, I want to run a query against systems to populate lstComputers. If optCheckIn is selected, I...

Solved. Under listbox properties, type your query in "Row Source," and change column count to the number of columns ;)

Hey guys. I need some help. I want to create a form with a list box populated with records from a query. I select "Create form in Design Mode," then I drag a listbox onto the form and choose the option "I want the list box to look up the values in a table or query." Then I select the query...

Doh!! Well I understand joins now... thanks.. .Perfect!

Hi... Great forum you have here. Glad i stumbled across it. So... I have two tables: Systems and Employee. I am trying to pull all records from System. However, not all Systems.EmployeeID fields are populated , and the query only pulls records where Systems.EmployeeID is not null. What...