Search results

Hi all, Just wondering whether the Access calender has conditional formatting where the day can be a different colour when a certain condition is met. Note that there'll be a condition for EACH day... I'm just brainstorming at this stage to see whether my idea can be executed... Basically my...

Hi all, I have a main form with a function called vbaPlayingTimes. I also have a popup form with a cmdClose button which closes the form. When this command is clicked, I want to execute this function (which is coded on the other main form), whats the coding to do this? P.S. I will have this...

Hi all, I have a listbox with values queried from a table. The table has a yes/no field that I want in the listbox, also as a yes/no check box. Is this possible? Cheers

Hi all, I'm placing some combo boxes onto a form, and I need just an "Open" or "Closed" option available for users to select. Can I have some help with the coding? I'll be using this code at the "on got focus" event of each combo. I was thinking I could create a table with just "Open" and...

Hi all, My current DB has forms with logos used with custom fonts. By custom I mean I found a nice looking one from the web and I'm using it. Later down the track when I finish my DB and have it implemented, am I going to have to copy the font to my friends system?

Hi all, I've learnt two different ways from this forum to get a value from a text box. dim txtBox as control dim strTxtBox as string set txtBox = Forms("frmFormName").Controls("txtBoxName") strTxtBox = txtBox.value ...and... dim strTxtBox as string strTxtBox = me.txtBoxName.value...

Hi all, currently I have the following INSERT query... strSQL = " INSERT INTO tblEmployeeBusiness ( [Employee ID], ABN, [Business Name] ) " & _ " VALUES ( Forms!frmEditEmployee!cboSelectEmployee, Forms!frmEditEmployee!txtABN, Forms!frmEditEmployee!txtBusiness ) ; " The primary keys...

Hi all, I believe prevention is the best cure, but what I'm doing is overkill I think. I have an Insert command button that is enabled AFTER this combo is updated. BUT, I know somewhere down the line a user may clear the combo, making it null, which will in turn cause an invalid use of null...

Hi all, I have two queries, is it possible to minus one from another? SELECT tblTrade.[Trade ID], tblTrade.[Trade] FROM tblTrade ; MINUS SELECT tblEmployeeTrade.[Trade ID], tblEmployeeTrade.[Employee ID] FROM tblEmployeeTrade WHERE tblEmployeeTrade.[Employee ID] =...

Hello I never knew how addictive/fun access databases could be. Many thanks to this forum and the gurus. You all know who you are! My first project was a basic timekeeping system for a mate's firm. He's able to find the times each employee's spent on different projects. Giving him costs and...

Hi all, Basically my listbox lists the results of my query. The list has 3 columns, 1. [Employee ID] 2. [ABN] 3. [Business Name] Column 1 is hidden, and listbox is bound to column 2. If the user makes a selection from that listbox, and clicks delete, things will delete as planned. But there...

Hi all, I have a listbox displaying query results. Column 1 is hidden, 2 and 3 are displayed in the listbox. My code below shows me that lstBusinessDetails.Value gives column 1's value only. How can I get column 2's value? Private Sub cmdDelete_Click() Dim selection As String Dim cmdDelete...

Hi all, My table, tblBusiness has two fields. [ABN] and [Business Name]. ABN is the primary key. I've currently got a form to add data to this table, and looking to create my own error message when the user tries to use an existing ABN. I have two choices. 1. The long way. See if the form's...

Hi all, I need a custom format mask as follows... xxx-xxx-xxx where x is a number only. This format mask will be used for a textbox that will input the number into a table. What is the best data type to be able to save this number? And I also need to keep in mind that when I retrieve this...

Hi all, Just wondering whether any aussies can help me here. I don't mind help from others, but my question involves the Australian Tax File Number (TFN) and Australian Business Number (ABN). Basically the rules with the Australian employment and tax system is that (when you're legal to work of...

Hi all, The below thread shows how to use a FOR EACH statement to go through each control of a form. http://www.access-programmers.co.uk/forums/showthread.php?t=157256&highlight=control I wanted to use this idea to CLEAR all TEXT BOXES in my form. So far my code is as follows. Dim ctrl As...

Hi all, By f22a at 2008-10-15 I'm sure most have you have seen this error when implementing your project from your system to the client's. Now before you give me a link to update my MDAC to 2.8 please believe that I've already tried that. My client's XP machines give the error... "MDAC 2.8...

Hi all, I'm quite close to completing my first small project. By small I mean that there's no SQL server, all tables (and forms and reports) are within the mdb file etc Now as this is my first, I'm sure the best way NOT to implement this project was to simply "email" to my friend. Of course...

Hi all, This isn't the right forum I know but I'm sure there are some who know VB scripting for Windows. I remember I had a simple script for a msgbox reminder every few hours a while back. If anyone can help I'd like a script so that I can execute a program (eg. C:\Program...

Hi all, Here's my code... Do date_box_str = "txtDay" & counter_day Set date_box = Forms("frmTimesheetManager").Controls(date_box_str) hour_box_str = "txtProj" & counter_proj & "Day" & counter_day Set hour_box = Forms("frmTimesheetManager").Controls(hour_box_str) hour_box.Value =...