Search results for query: *

Ok here is my problem :) On the Report_Click I opened my report Docmd.OpenReport ReportName , acpreview It runs Report_open If OpenEvent = False Cancel = True End if Function OpenEvent as Boolean If my data is correct everything will be fine If my data is incorrect it runs Cancel =...

Heya there Thanks a lot for that solution. I thought of that one but it uses tables. At least it does what I want :) Thanks again I will use that one .. guess there is no way to simply select and put in clipboard w/o using those tables. The Dreamwalker

Thanks a lot everyone for your help Ok 1st... the macro thingy would work but Im not using any button or any tables from the database like I said earlier. For you Jim ... the program that has the unmasked text field is not mine its another application Im using ... and I cant do anything about...

Ok :) I know it seems wacky and things. But the thing is that Im working for a company wich I have no choice to deal with that lame program that I dont know who coded it. I have no access to source code and there is no mask for the phone #. I created a little form with a text box that has the...

Hey everyone I will explain again my little problem. I won't use any foul language. I dont think I ever did but anyways. I have a simple form ... with a simple text box. The only things I want to use is this text box the text box data and the windows clipboard. Im trying to find a way to copy...

Heya everyone ... I have access97 in front of me ... I am trying to copy simple data from a text box I have on my form called Text0 Im wondering how I can take this data and auto copy it into the clipboard via VBA coding .. tried searching the web but did not found what I was searching for...

hehehe 1st create shortcut 2nd go to properties 3rd write this in the TARGET PLACE "WHERE IS ACCESS" "WHERE IS THE DATABASE" /WRKGRP "WHERE IS MDW" thats my example ... EVERYTHING on one LINE ..(TARGET) "D:\Microsoft Office\Office\MSACCESS.EXE&quot...

there is preprogrammed functions .... check for the one call isLoaded ... will return true if the work is active false if not ... hope it helps Vince

Hmmm Select column1, column2 from table where column2 > column1 that is quite simple no ... unless I dont understand correctly your question Vince

Does any know what the heck is this error and how to remove it ... pleaseeeeeeee its my last bug :| Thanks again Vince

Guess no one knows what those errors are and how to remove them Thanks Vince

hey hey Try this when you open the form in vba DoCmd.OpenForm "formname", , , , acFormAdd Cheers Vince

Thanks again for the logging help ;) I did everything within a few hours :) Ok here is the new questions ... if I modify a form ... and I try to close it ... it gives me the error that the object cannot be saved ... or such ... an access warnings ... I was wondering if there is anyway to remove...

woah thanks ... whats the size of it ... vince8101@hotmail.com if its too big send it to jlangelier@ergoresearch.com Thanks Vince

Hey everyone ... I was wondering ... is there any functions already done to log what users do while connected to your db ... I did a log of LOGING/LOGOFF ... but for what they modify never quite worked on that ... you have any idea ?? I would appreciate if someone already done that on his...

Your doing work that has not to be done but it can be done that way too ... Tools -> Startup ... the form that opens would be the Login one containing your text box ... with a button Login ... On that click you check in the DB and verify the login + password ... If correct you open another...

Create a table with username and number of time entered ... on the loading check wich users connected with Currentuser() and write in the table the count ... if the counts = the number you want then just close the application with a message ;) Cheers Vince

Hey there 1st Create a function that will add the correct WHERE condition for your selected items .... after use this loop For Each varElt In lstEtiquettes.ItemsSelected If lstEtiquettes.ItemData(varElt) <> &quot;&quot; Then Call AddCondition(&quot;PrimaryKEY = &quot; &...

It can be a TABLe or an Access Query Name Vince

ok I know there is no way to put text in the status bar if your or on a form ... but if you set the focus to a control textbox, command button or anything else you can access the statusbartext property Cmd.StatusBarText = &quot;BLAH&quot; Vince