Search results

Thanks, I ran an update query PB

Morning everyone. Tis doesn't seem too difficult, but as with most of my Access issues, I just don't know the syntax or what keywords to search on. I have two fields I'm working with (many more in dbase). One is a date and the other is a text field with yes/no (should have been a y/n field but...

Thanks Beautiful..... PB

I have a form that calls an Excel spreadsheet and runs a macro. The macro is large And runs over a network so it is also slow. As it stands, the only thing it does is lock up the Access window until the macro has completed. My boss immediately said, "Well how do I know it's running????" He...

addendum I didn't understand your entire question. The previous post will open on a specific record but I'm not sure about the sub Form sfuff. Sorry if I wasted your time. PB

Hope this is useful Go to the Forms button on the database window. Select the form you will be working with Right click on it and bring it up in 'Design View' At the top there should be a ruler bar. Just to the left of the ruler bar is a gray sqare that looks like it's just a place holder...

Hi all. Here is the situation. I have a form. I put a button on it following these steps. Drag the button from the toolbox onto the form. Choose Record Navigation and Find Record from the list boxes. Choose the Icon and Name it. Now, the search box pops up after clicking the button. The...

Ooo You know, that is a great idea. The only difficulty is that my boss wants me to automate something that is already in use, so I can't make this file autorun a macro because they use it every day and the macro updates the data. Good thinking though. PB

George Too, very nice code for exporting. It solved many problems. What's the syntax for launching an Excel macro in the With ExcelApp mode? So far I have Set ExcelApp = CreateObject("Excel.Application") 'With the new workbook do the following With...

Got it Sorry to have bothered you. I was looking for an export option when the Syntax is actually OutputTo. Never mind Thanks PB

Good morning, I can right click on a report and export it, but is there an option to have a macro do it or some code that will do it from a module? Should I ask in those forums instead? Thanks PB

Thank you. Thank you. PB

Thanks Wow, you are good. Seems you've been answering most of my questions. Much appreciated. Thank you. PB

Hello all. I need to mine out entries in a database where the date field was left blank so it can be entered (why didn't they make it a required field in the first place). When I try to query on a date field with criteria = to nil or empty I get a type mismatch. Anybody know what my criteria...

Hi all. I've got a query that needs to look for empty blocks that normally contain a date. In the macro designer, I'm using: Field: Expiration Date Table: Training Sort: Show: Check Criteria: ???????? I've been trying to use nul, or empty for criteris but I get a type mismatch. What should I...

addendum I was refering to using a macro above. Sorry. PB

Hi, When exporting a query to Excel, it's easy to just send it to a spreadsheet, but can it be directed to a particular cell?? If not, can anyone tell me how to set up a module to do it? Thank you all so much. PB

hmmm Thanks. I also had to change Combo42_OnChange to Combo42_BeforeUpdate. This seems counter intuitive to me. Anyone know why OnChange isn't the correct choice? PB

Hi, all. I have a form with a comboBox on it. It has two choices. When I choose one I need it to run a particular macro. The macros do not launch as is. What is wrong with my code? Private Sub Combo42_OnChange(Cancel As Integer) If Combo42.SelText = "Cost Center Sort" Then...

Thanks all I got redirected to the Excel specific forum. I didn't know there was one here. Anyway, the chart.Add is the only way I know to generate a chart and I also added new code to delete all old charts before the .add and it still keeps the old count??? I appreciate your response. I'll...