Search results

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

Cheers bob!

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

based on the information u've given i'd simply use dim strSQL as string strSQL = " UPDATE yourtablename " & _ " set yourtablename.machine = Forms!MachineStatus!machine " & _ " and yourtablename.time = Forms!MachineStatus!time " & _ " and...

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

lol omg it works! cheers :)

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

Sorry Bob, no luck with that. Changing to "date_box_str" had the DLookup looking for values "txtDay1", "txtDay2" etc from "tmp_tblHours" when the field values I need are dates. I've also tried the below without any luck... hour_box.Value = DLookup("[Hours Worked]", "tmp_tblHours", "[when] = #"...

There's no null in the datebox. It's populated automatically as form.open :( I'm still playing around with it....hope I get it working

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

Sorry smee again. As you all know, with this issue I just had, I created a temp table (via MAKE TABLE) then retrived records via ADO recordsets. Sorry for my n00bness, but as I was looking through my code, I thought I was able to omit creating the temp table, and use "recordsets" instead. I...

Cheers fellas, you've all been a great help! :)

You guys don't know how much I appreciate your help with this. It's helped out a s**tload :) Just out of curiosity though, I'm stunted by this code by Sato If rs.EOF = False Or rs.BOF = False Then What's this mean?

Alright Satal, I've done what I could next and started reading on ADO's and connecting to Access files. There is however already a problem. When I try make an ADO connection to my Access project, there's a message saying that my database is in a state that prevents it from being opened or...

Sorry I just realised after posting that it's the same. Cheers buddy! ...and yeah I'm gonna have to go into learning about record sets...

Tranchemontaigne, I'd like my output to be as two separate records in this case. As my criteria would be where TS_Date = 22/10/2008. It is possible that this criteria may give even 3 or 4 results. If that happens, I'd need also need those 3 or 4 results as separate records (preferable into...

Hi all, Been stuck on this for a while...was hoping for some more help. I have a temporary table like such TS_Date Project_Name Hours_Worked 19/10/2008 Dalkeith 0 20/10/2008 Dalkeith 4 21/10/2008 Dalkeith 4 22/10/2008 Dalkeith...

you bullies :(