Search results

Thx Moniker, I will give your suggestion a try. CementCarver

Hello All, I'm trying to build a recordset joining two tables together. I can get the join to work, but I need to use an "or" statement to fill my rs.values Here my statement so far: mocommand.CommandText = "Select JUNK.[MS], JUNK.[CNT]," & _ " LINK.[FROM]...

Hello All, I have an interesting situation. I'm working with a large table that contains a shape_id, sequence_num, x_coordinate and y_coordinate. The shape_id holds a unique identifier for the polygon and the sequence_num is a number that either starts with zero or one. This sequence_num may...

Matt, My client was very happy to see the calendar pick form and didn't have one other comment regarding the db. So I owe you one. Plus my supervisor was happy too that the tool was delivered. I'm in the process of looking up VB courses being offered here in Ontario, primarily Mississauga...

Matt, I borrowed a Vb book from a friend, but it was way too complicated and I need to start from scratch.... so the VB for Dummies sounds about right for me. I'm calling it a night............Walter

Matt, I'm just downloading your revisions to my db. I'll take a look at it and see how you managed to transfer the date from the calendar form to the three fields in question..... Man, it works like a charm.....!! I noticed that you put a submit button on the bottom, rather that the...

Gizmo and Matt, Thanks gentlemen. Gizmo, I've viewed one of your videos and looked on in interest. But you last post regarding the "Copy the class "clsGetActiveFrm" Into your project" I do not understand. Matt was nice enough to supply me with a copy of his db and I could basically understand...

Matt, That's very kind of you. I think I butchered my copy last night while we were talking. I was at work and stayed late and all I ended up was just getting frustrated with nothing to show for it. The form I'm trying to get the date to populate is called Mpac_tracking and you'll see the...

Matt, All I have are Calendar Control 9.0 and I've been able to design a new form and use that Active X control. I was able to use the box to the right of your Change form to activate the calendar, but now it's not passing the value I select back into the field I need it to populate. Plus I'm...

Matt, I'm kind of getting the general idea on how your db is working, but I'm getting an error regarding setting a variable for the following: Me!ActiveXCtl0.SetFocus ActiveXCtl0.Day = ThisDay ActiveXCtl0.Month = ThisMonth ActiveXCtl0.year = ThisYear ActiveXCtl0.Refresh Where does this...

Matt, Downloaded your link to your database. Sorry about the stupid question about logging in... I thought you were referring to logging into this forum with that password.... I'm reviewing your code now. And, thanks very much for being so helpful. I'm in a drastic learning curve and need all...

Matt, What username to I use to login? ...Walteer

Matt, So you use the case 1,2,3 to set the default date? Is this set in a box beside the date field? I'm not too well versed in this programming environment and I'm not really sure how you use that global variable to set this date value. Can you please offer more code/help? ...Walter

Thanks Matt.......I'll give your idea a try. ...CementCarver

Thanks Gizmo Many thanks. I'll download the free calendar and check out the supplied videos too. ...CementCarver:):)

Hi All, Thanks to "Beginning Access97 VBA Programming" by R. Smith & D. Sussman, I was able to implement the use of a calendar form to allow a client to select a date, rather than keying one in. And here I thought I was done with the problem....Wrong !!! The calendar form only works if existing...

Uncle Gizmo, Thanks again. I'll give it a try. CementCarver

Uncle Gizmo, Thanks for your help. I saw the 6x queries in your first reply. So do I just need to run the latest query supplied ie. qryNeedUpdate in the pointsonplan_3 database? CementCarver

:)Hello, I have one Access table called plan_location where it contains the following columns: shape_id (number), seqnum (number), xcoord (number) and ycoord(number). The shape_id is a individual number for each planname, the seqnum is the number of points in the plan and the xcoord ycoord...