Search results

It's been a while since I've been on the boards. Good to see lots of the same folks are still here. :D I've got an interesting problem. I have a sub that calls another sub. Pretty simple there. The problem is that when sub A calls sub B, sub B does not appear to run. This is all sub B does:If...

Call an Excel function from Access As long as you've got Access and Excel on the same machine, you can make a simple automation call to Excel and use Excel's built-in functions. Here's a simple example using the Excel Small function:Function GetNthNumber(intPosition As Integer, _ ParamArray...

I've got a form with a textbox. Next to the textbox is a command button. This is the code in the click event of the command button: Me.txtEnteredDate = Now() The code works. My problem: sometimes the textbox immediately shows today's value. Other times, I need to switch to another screen, then...

I have a user with an Access database. He's got 50+ tables, and roughly 10 fields in each table. The fields are the Double data type. He'd like to have them display as "Standard" with 0 decimal places when the table is opened directly (purely a cosmetic preference on his part). Anybody know the...

I have two tables with the same structure in a list matching application. I've having a problem understanding the query results, and I've created a simplified example to show the issue. The first table, tblTestAll has 5 records, the 2nd table, tblTestSome, has 2 records. These records all have...

Anybody ever use Access to create a pseudo-schematic of a floor plan? I created one in order to track computer equipment and employee seating on my floor. I am looking for comments on the following and any suggestions you could make. Thanks! 1- I'm thinking about using Visio for the actual...

Let me explain.... I have a query that looks something like this: SELECT * FROM tbl1 INNER JOIN tbl2 ON (tbl1.Field1=tbl2.Field1) AND (tbl1.Field2=tbl2.Field2) AND (tbl1.Field3=tbl2.Field3) Now what I want are the records that are not selected, basically what I would get from: SELECT * FROM...

Hope you guys can help me out here. I have a select query based on a single table with a few calculated fields. One of the columns takes two previous columns (one of which is calculated, one of which is taken directly from the source table) and subtracts one from the other. Basically the...

I posted this question about a week ago, but got no responses. Hopefully I can explain it more clearly and get some of your ideas. I have two combo boxes on my form. In cboA you choose a field name. Based on that selection, I have code like this which assigns the row source of cboB: "SELECT...

I've got two combo boxes on a form. Combo box A displays a list of fields taken from a saved table. When a user selects a field from combo box A, combo box B gets filled with unique entries from that selected field. The form does this using a SQL statement to fill combo box B's rowsource. It...