Search results

I'll try and whittle it down and post it.

This time the query would open in Datasheet view but if I opened in SQL view and then tried to go to Design view I get the error. I can't get to design view right click the query either. SELECT [IN Whse Qty Invoiced History].INWH_PART AS Part, [IN Part Master].INPM_DESC, [IN Whse Qty Invoiced...

I had to dump the database so I could try again. I couldn't open the query in SQL (it was disabled) to see what was going on. I couldn't open it in design view either. I am trying it again and will get back to you. Did you get a chance to see how low Shasta was. We went up to Washington just...

I want to link tables from another Access data base but when I build a query and save and then run it I get the attached error. It also won't allow me to delete the link or close the data base once the error pops up. Any suggestions? I have copy/pasted the name of the table, AP Vendor Master...

Thanks Paul. This question will indicate my lack of knowledge. Do I use this in the Option box case statement or in the function module?

I replacing data periodically into a linked Excel file and depending on the month the analysis is taking place it uses a different query as a record set. If I could change the record set with a case statement and use this as a function that would be nice. I just don't know if it can be done...

I found my problem. While testing this procedure I encounter an error. This seem to leave the file open and when rerunning the process the file was considered as already open. When I did Ctrl/Alt/Del I had three instances of Excel open but non visible. Thanks for your input.

Thanks Paul the made it work. I sold my business in 96 and moved up here on some property along the Sacramento river. Best thing I ever did for myself. I thought I really like San Francisco where my business was located but now I can hardly stand to be there for more than a few days at a time...

This code seems to give me an incorrect result with the rs!Position = Me.Employee.Column(3) in the below code. It gives one of the Position names for all the employees selected. All the others give me the correct results except for that one Private Sub cmdAddRecord_Click() Dim strSQL...

Is there an issue with using acdialog and opening a form in DS view? When I run this code the parent form comes right back but none of the controls are enabled. Is there some setting I am missing? I though acdialog was supposed to reign king until I closed the other form. Any advise is...

Complain time. The program min restore and close buttons become disabled while building a db. Sometimes it happens in the code window also. I am using a stand alone version of Access 2007 with a Student version of Office on Windows Vista Ultimate OS computer. This is not critical, as I can...

I have this function to run several Maketable queries after another table has been updated but when I try to run them from code during the delete it errors out 2387 indicating the tables cannot be deleted as they are participating in one or more relationships. However they run perfectly from the...

I keep trying but LA seems to be getting all the water. Our lake Shasta is down so low you can see buildings and parts of the old Highway 99 bridge and road. In fact thery are using the highway as a boat ramp. As you probably are we are also in about the 4th year with less than 75% of normal.

Thanks Paul and RG that made the whole thing work. This db world is full of details. It's really nice have people like you willing to share your knowledge.

I have a multiselect listbox with the below code that errors out to "Method or data member not found" the error point stops at "rs.Position = ctl.ItemData(varItem)". I have attached the form and a screenshot of the table referenced. It has to be some little thing I am not seeing. Please advise...

Thanks again Paul.

Paul, I apparently don't understand how this code you provided me for using a MultiSelect Listbox, works. With my limited understanding I modified the code as shown below but the results are not, what I am sure, you intended with the code. The following results occur when I select 5 employees...

Thanks Paul this really helps.

Thanks Paul, that sounds like a good suggestion. I will figure out how to do that and see how it works.

I have a form to update training records (see attached). This normally will be used to record employee training for a specific training policy. The entry will be repeated for up to 30 emplyees all training in the same policy. I would like the user to pick an employee and for the first time...