Search results

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

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 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 & ";"...

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

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

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

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?

This problem is making my ::boggle:: In two separate locations with different users I have had an issue where they have somehow made changes to their front ends when the front end is saved as an ACCDR. Their computers only have the 07 run time installed. It was my understanding that no changes...

I've noticed in the past that if I have a button control on a form and have an code like such behind it: Private Sub BtnSaveClose_Click() currentdb.execute "INSERT INTO tblTable.* FROM tblTable.*;" DoCmd.Close frmForm end sub If I double click, or just click fast enough I can fire off...

I've made progress bars in the past and I've sync'd replicas in the past. But something that's always been a problem for me is meshing the two together. With Access 2007 is it possible to create a progress bar for use during: Dim db As DAO.Database On Error GoTo CmdSynchronize_Click_Error...

This is definitely an aesthetic question, currently in Access 2007 the default text box uses a blinking "|" as the indicator for where the text will be placed when a user types. Is there a way to change that bar to the old "_" underscore like on a terminal application? I've been playing around...

http://www.dispatch.com/live/content/national_world/stories/2009/01/29/iraq_shoe.html?sid=101 Iraqis build a statue to honor Bush.

Anyone ever work with a Closed Circuit TV system? A friend of mine purchased a Lorex and apparently is incapable of setting it up. I'm curious what I'm getting myself into. As it's been explained to me that these things can broadcast from their location to the net and he could remote monitor...

Hey all, I've been trying to set up a form that will allow a user to choose a default printer for a report, sort of like the functionality in the page setup options for Access (2007). All my searching is pointing me to Allen Browne's Print Selection Utility...

Up until recently I had been packaging something I'd been making in Access 07 and it would work without any problems. A few days ago I packaged up everything, like normal (I save a template for packaging so no changes are ever made) and take it to a station where an older version is running...

In the database I have inheritted I have records from two locations that use the same structured backend. The problem I have is I want to combine them. Example Below: TableSale SaleID * Date Total Location TableSaleDetail DetailID * SaleID < ItemID ItemPrice Quantity * = Primary Key < =...

I was listening to Hannity today. I caught a quick ditty that made me flinch. I've also heard this a few times before but I passed it out of mind, seeing as it is now on Hannity it seems this is now part of the media frenzy. This is not verbatim, I am paraphrasing. "If you tax the rich...

Something that I've always wondered about are the ways to sync up locations outside of the home office. I assume in the retail industry a point of sale system is setup at each location with their own backend. At some point, (Daily, weekly, Monthly) those stores sync up with the home office...

This is neat, I think anyway. I have a continuous form that displays the results with the background in stripes. I set the Detail section BG color to Yellow and when I display my results it alternates between yellow and white for each record. I'm using Acc 07 anyone have any clues ?

I've started work on a project, it's aspiring to become a Point of Sale but for the time being I'm focused on making sure that the inventory side of it is taken care of. I think I've got this set up decently. I figured I don't see this too often but attached is a picture of the table...