Search results

Found my error, as usual :( Originally, I made it a Public Sub(), but when I changed it to a Public Function() it worked correctly. Stupid mistakes.

I'm making my own custom calendar and i have 42 labels (each holds a day). Eventhough there are a max of 31 days in a month, sometimes days start off on a Wednesday or a Saturday, so there are 6 rows of 7 labels for placeholders (see the attachment). In each label's onclick i have...

2 Things: 1) To reference forms you generally use the Forms("Form Name") or Forms![Form Name] syntax, unless you have created a form object in your code and set it equal to a form using the above syntax. e.g., Forms("ListCandidates").lstCandidates.RowSource = strSQL2 -or- Dim ListCandidates As...

Close, that's what I would have thought but the chart objects are a little trickier to work with... Reports("Report Name").ChartObjectName.ChartTitle.Text = "" There are several different objects you can use instead of text, one might be Caption or Name

Sorry - I'm a little late on this, but thats because you were trying to change it while previewing the finished product. You would have to make the changes in design mode: DoCmd.OpenReport sReport, acViewDesign Reports(sReport).RecordSource = sQuery...

I don't beleive that RENAME syntax is available in Access 2003. It was implemented in Oracle 9i. To rename a column: - With SQL: - - add a new column with the same variable type - - update it with the old data - - drop the old column - With VBA: - - simply use a DAO tabledef and change...

Not true, 2003 utilizes both

Make sure SQL syntax has not changed

What exactly are you doing? You may not want to handle it this way. There are nice benefits to leaving the SQL alone (it speeds up data retrieval). A filter could better suit your needs.

are you talking about cache as in memory cache?

anything can be done.. the degree of difficulty is what matters; followed by "how?". what program are you running, is it in console? how do you expect to get the output?

Do a search on File System Object. From that you can use Access's VBA's intellisense to gather a whole bunch of information. Once you set up your fso, it's just looping through folders and files and loading the attributes into a recordset.

By the way, I am suggesting doing this by code, not the Tools >> Options ... uncheck Rows & Column headers. Just don't have time to look into the different excel objects at the moment. If no one has figured it out by the time I do, I'll post the solution.

Anyone know how to hide the Column and Row headings in Excel. Meaning, remove the "A,B,C,.." column names and "1,2,3,.." Row numbers so that you have a pure grid-based output. This is for a web based excel sheet generated by Access.

I avoid macros. DoCmd.TransferSpreadsheet 'use help if you dont understand parameters DoCmd.RunSQL "Query Name or Delete SQL here" DoCmd.RunSQL "Query Name or Append SQL here" DoCmd.RunSQL "Drop Table [tempTbl]"

When the spreadsheet is closed, after you transfer it, goto the table's design (right click the table and choose the design view) and look at the datatype of that field. If it is a number it is not transfering it as text. Furthermore, post your code, because I would like to see what you mean...

bump - possibly make this a sticky - if this thread was useful, please post. it will let me know how up-to-date everyone is staying and whether or not i should post other links like this in the future

As posted by Microsoft, "All of the domain functions are based on the same query (over the underlying dynaset). If one of the bound functions on the form has a binding error, all of the functions on the form will return an error." So find which control has the error and remove it.

First, you should declare CurDb as DAO.database so that it is not confused with ADO Second, what is your control source for the textbox

Not the best way to output data, mainly because you're using a string which has a limit. If you hit a lot of data, it will not work. What exactly are you trying to do? If you're just trying to output a recordset, such as a table, the best way is to use Access's built-in function...