Search results

What about converting the string to an integer or # variable?? would the inputmask accept it then?? you would have to remove the dots before you could convert it though. im not even sure if this would work or not. - Topher

The problem with that is i'd have to put the name of the form in quotes - i have 40+ forms and if i add some later i dont want to have to keep adding lines of code to open the form - plus this would really slow things down b/c it opens all the forms one by one changes them and i guess i could...

hmmm i might be able to help ya. ok if you want it to check the dates at the startup then the dates that are entered are saved in your db right?? if so then you would have to create a recordset via a query - that checks the dates in the table to the current date. and also open a recordset of...

Welcome =D you dont know anything about changing the properties on 40 forms at once do you??

when u say it didnt work on the other records is it b/c you are cycling thru them?? hmmm if you are - try putting it on the On Change event... actually you should be able to put it on the On Current event. that event is supposed to control the current record - so when you change from one rec...

hmmm what event are you using to check when the date changes?? i believe you want to put your code in the AfterUpdate event of the txtbox where you enter in the date. the code will only run, once the cursor moves out of the txtbox. how do you have your information set up in the combo box?? is...

good day all, im hoping someone knows how to manipulate the properties on forms thru VBA code?? the thing i want to do is change a few properties on ALL the forms in my DB - theres about 20 or so. i've bin able to figure out the code using collections to list all the names of the forms. If...

good day all, im hoping someone knows how to manipulate the properties on forms thru VBA code?? the thing i want to do is change a few properties on ALL the forms in my DB - theres about 20 or so. i've bin able to figure out the code using collections to list all the names of the forms. If...

Hey there, im not sure if this will help you but this is how i did what you are trying to do but using word. i believe i got most of the code straight from one the command button wizard Dim oApp As Object Dim path As String path = THE DOCUMENT (PPT) YOU WANT TO OPEN Set oApp =...

The type mismatch may be coming from appending the Me!ID to the string - it may be in an integer or number format - if it is then you may have to change it to string format b4 appending. also have u tried using a filter?? is this a report you are printing? - Topher

Hey Access PPLs! I got a whopper of a problem. I need to cycle thru all my tables in order to find a field name and then change data in that field name. I was hoping this would be easier than going thru all the tables manually, finding the field and putting it in a big list of SQL Code. Is...

SWEET!!! it works! thanks guy!

Oky Doky heres me problem. i'm trying to list the results from 4 different queries in 1 list box. the results show up depending on what the user selects. that works find and dandy, BUT what i want to do is make some of the columns smaller and some larger - depending on the result chosen. i...

I got it working, thanks a lot =)

that sounds about right - but i can't get it to work properly - i think it has something to do with the use of 2 tables. one table holds the Date along with other information - and the other table holds the numerous records which link to the date. a one to many relationship i believe. the...

I hope someone can help. I'm trying to create a report that will force a new page after the date has changed. So say i have 5 records with 5 different dates. date1 with record1, 2, 3, 4, 5 date2 with record1, 2, 3, 4, 5 etc... how can i create a report that would force a new page on each...

i believe you can, by creating a string variable with the SQL Query statement in it, and appending the date variables to it. IE dim strSQL as string dim begindate as string dim enddate as string strSQL = "SELECT table1.* FROM table1 WHERE table1.begindate = " strSQL = strSQL & begindate & "...

I'd like to know if its possible and if so, how? to open word thru access and have word open a document which is referenced in a table in access. IE TABLE1 has a field with "C:\readme.doc" in it i have a button which will open word but how can i get word to open that readme.doc file...

sorry i meant acViewPreview not acViewReplace! oops

Thanks for the info - i tried what you said and it does print however the dialogue box doesnt appear. i think its because of using the normal mode for opening the report - normal means to print it, right? i replaced the acViewNormal with acViewReplace and it worked!!! =D Thanks!