Recent content by ASherbuck

Thank you for sticking with me. A starting point was another idea I thought about, I'm glad you reinforced it. And you're right, months with shorter dates were the problem. It was accounting for the partial 5th week that made this so difficult. The booking system sounds like a win. I...

Gotcha, here's some clarification. I've got a schedule table as such: tblOperating Hours | dept_id | day | location | open_time | close_time | 1 | 1 | 5 | 0900 | 1700 | 2 | 1 | 5 | 0900 | 1700 | 3 | 1 | 4...

I have a normal schedule table in my database that stores the open/close hours for each business unit location. The problem is some locations are timeshares and some have different business units every other week, every 2 Tuesday, the 1st and 3rd weeks of the month. I figured I would make an...

That's a pretty sweet trick. I'll give it a shot on Monday. If it works for me this could save hours of headaches. Thanks

FrmItem uses a table for a recordsource and has text/combo fields to show the data. FrmItem has a subform, frmSearch. frmSearch let's you search by name for an item and lists the results in its detail section (continuous form). Clicking an item on frmSearch navigates to that record on FrmItem...

I was using isCustomer(1) and isCustomer(100) There is no account #100 in my DB and that's where I was getting this odd behavior. Oh wow, right in the middle of typing this I decided to Debug -> Compile and it went through fine but now I'm getting the customer not found message. I swore I'd...

I have a class, Customer When I call the following function I have strange behavior: Public Function isCustomer(custID As Integer) Dim db As DAO.Database Dim rs As DAO.Recordset Dim sqlstr As String isCustomer = False sqlstr = "SELECT * from tbltmpCustomer WHERE iAccountID = " & custID & ";"...

What? You haven't been watching Fox lately have you? ::snicker::

Here's a goodie: Package developed on Windows 7 Access 07 When deployed to a Windows 7 machine it runs fine. When deployed on Windows XP Home, Pro, Pro SP3, it crashes as soon as vb is run - "Execution of this application has stopped due to a run-time error." I was chasing this for a while...

I needed that this morning, thank you George.

I'm going to throw out a tip as it's worked for me and I haven't seen it recommended on the boards. When I'm having a hard time with sql I just use Access to build my query the way I need it. I can test it (Except for code variables but those are easy to substitute in code - it also helps me...

They're telling you to hit F1 while looking at your code and search for Rnd() or Randomize.

Currently I'm using the following in access 07 MyConnectionString = "ODBC;Driver={MySql ODBC 3.51 Driver};Server=SERVER;Port=3306;Option=131072;Stmt=;Database=MOTDDB;Uid=USERID;Pwd=PWORD" Set db = OpenDatabase("", dbDriverNoPrompt, False, MyConnectionString) and it works fine for what I...

That nailed it. Thanks so much for your support with this.

I have been able to create an identical DSN from scratch and use that the same as the original. I have connected to the database using SIDU - opensource browser based client and it correctly displayed the only table I have in the back end. If you're interested I have no problem giving the...