Search results

You may need to rethink your approach and simplify it all ... This looks realy heavy :O(

Do you have LOTS of customers in those tables ...or is it under 100 ?

Indeed..trainers are used for local play and not online. I used to think they were bad and all but its not so bad afterall... it's you and your game. If you wanna cheat your local game for any reason ex.: To hard for you ( THAT is not excusable ;) You went trough the game and now want to...

Here is a bit of code i use to create an event number for a log The output text is ex.: 20060119003 as in (2006-01-19 event 003) Dim strevent, eventDate, prtEvent, EventNumber As String eventDate = Format(Date, "yyyymmdd") strevent = DMax("[ID]", "tblLog") '*** Look in the tblLog table...

First.. make a button and in the "Conditional formating" make it that if there is a value in the note field..it shows the button. Second Link your button to a pop-up window with all info and make all field Locked = Yes Enabled = No

Maybe you can try and remove the now and replace by Date repMonth: (IIf(IsNull([returndate]),Format(Date,"mm/yy"),Format([returndate],"mm/yy")))

Greg.. you could also merge your 2 table and add a field "yes/no" ..a checkbox if you prefere and set no to all "non active" customers...

We are so cool...AND nerds LOL

Yes sir.. Laval would be more like it ;)

i hear ya mate "On est des vrais" ;) yep..i MAY be your "voisin" you know Newman ;)

I dont know what the word means and i think i am not an "escapist" But i will surely think about it all in my 16hours gaming time i have in week-ends and see if i am..but i doubght soooo much :)

When i was a young chap with no life and no future (we are all like that before the 20) i was looking at those weird guys called "nerds" and tought they were realy out of it and realy weird. They were reading books and books, coding and coding...just for fun sometimes. THAT was not acceptable in...

If you still have access in your forms in the background to edit and save... put a buton somewhere (temporary) in your starting page and put that code behind DoCmd.RunCommand acCmdStartupProperties now when you open your document..click on that buton and your startup properties should appear to...

in access you start your line with the " ' " sign exemple : '********* This code is to build something i realy need ******* Then you start your code right under '********* End of exemple******* dont comment in middle of lines...your codes will be a mess...

How about ... On Click event of a button Dim strFilterEvents as String strFilterEvents = "zipcode = '" & [Zip] & "'" DoCmd.OpenReport "MyReport", acViewPreview, , strFilterEvents it goes like this you open a report of your choice (MyReport) in preview mode (or put it normal..as you wish)...

Now i am REALY mad at myself. I figured it out after watching my cats play (Dont ask ;O) DoCmd.RunSQL "INSERT INTO tblData(DataName) SELECT fldName FROM Table1 WHERE chkStat =0; " Cant you have more simple then that... INSERT INTO my everyday table, SELECT the field fldName FROM Table1 WHERE...

The problem with your solution is that i would need to go trough the contract and there is no way i have time for that..i recieve 30 calls in 15 minutes (sometimes more) and i have to make the input fast and easy (lets say lazzzy). What i realy need is a continuous form with all active contract...

Hello all Im have a table that contains contract that are active or not (tblContract) and a table that contains my every day data for each active contract (tblFldDat). Every day i need to populate my tblFldDat with active contract number. that will result in a nice continuous form that i will...

You could also make a form unbounded and do a "INSERT INTO..." statement

14 views and no reply..it may not be as easy afterall ;)