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

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

Thanks for the response Banana, I've made the changes to reflect: MyConnectionString = "ODBC;Driver={MySql ODBC 3.51 Driver};" & _ "Server=XXX;" & _ "Port=3306;" & _ "Option=131072;" & _ "Stmt=;" & _ "Database=XXX;" & _ "Uid=XXX;"...

I've been reading many posts by Banana concerning remote back ends and connection strings and something that's been throwing me off is when I try to create a recordset based off my remote mysql server. I snatched my connection string from Carl Prothman's awesome site. The code is as follows...

Thanks everyone for the input. The work consists of pieces of projects I have worked on for others, but is completely stripped of any recognizable traits - Logos/Themes/Etc. It's just the basic functionality. I think I get it, though. Keep the resume concise and simple, if they're interested...

Not sure if this belongs under small business or if the Watercooler will do. I'm beginning to put together a resume and I'm having a heck of a time figuring out if it's normal to attach a sample work with your resume. Anyone have any experience with this and know if that will hurt/help your resume?

Dfenton nailed it. These are design changes that are occurring on my forms through the run time. There is no problem with data anywhere.