Search results

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...

That $8,000 will immediately be taxed and you'll receive about half of it when it all pans out. The remainder will be chopped up into tiny payments that will be dished out with every pay you receive (should be around $42.00 extra in every pay), of course there is a chance you get half up front...

The humor comes to me from the realization that there are people who really do only put enough thought into life to take this chain letter as a definition of reality. It makes me think of someone living in a trailer with a huge satellite dish on top of it - causing it to lean to one side...

I needed that this morning, thank you George.

If you feel warm and safe inside the pocket of big business, hate homosexuals (bonus points for hating them while being in the closet yourself) and you believe that science is just a theory made up of fancy words to confuse you because you know that your car runs on God's divine will and the...

Yes, back in the day it was better to prescribe Opium as a cure to alcoholism because Opium addicts didn't come home and beat their family members. Those were the days, indeed.

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...

Are you saying that you got the Delorean up to 88 M/H? The Constitution also says that only white land owning men are allowed to vote. I suppose that was good in it's original form as well? This is why I call the Republican/Conservative party the Regressive Party, should change the animal from...

Racism Ignorance Stupidity Greed Selfishness Republicanism

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