Search results

I want to create a function that opened an excel file from shared directory. Should I use macro or VBA? What's the code in VBA to link excel? Thank you.

Thanks for the prompt reply.

How do you set the rs in the code below? The source data for my Form comes from a query. I want this function to go the next record in the form until the end of file. Public Function AllocateMonth() Dim rs As Recordset Do While Not rs.EOF if me.Start ... ... ... ...

Thanks guysss. It works great.

What about a code to maximize window everytime a form opens? Thanks IMO.

How do you code in the VB to center a form everytime you open it? It seems that my autocenter attribute in the form properties is not working. I have 2 forms with same sizes. I want them both to open in the center on top of each other. Thanks...

Can you print from an unbound textbox? Because when I print it, it doesn't show. It shows in the form though. Is it because the textbox is in the subform?

I have problem with totaling subtotal in a report. My Total Resources data is generated from a query. The Area Total is the sum of Total Resources per Area. There are 5 area in the report. Now, If I want to subtotal the Area Total, I always get the input form, Area Total. What should I do?

I don't think you can add, edit, delete data in the query. So, if you're making a form based on a query, You'll be using them for viewing only. At least that's what I think. Anyone ?

On the Access side. When the linked table is created, there are some #Num error in it.

I have a problem with creating a link between Excel spreadsheet and a table in Access. When I finish linking it, Some of the field is listed as "#Num!". I tried changing the cell format from "number" to "general" to "text" in Excel, but nothing seems to work. Anybody know what's wrong with it...