Search results

Well, Indeed I had another post in another section which was that I could not use parameter in the query in question. Nothing I read on query parameter in this forum seemed to work. Well I just tried a parameter query in a MDB instead of a ADP and it works!!!. So I guess my question is now, how...

sqlstr = "SELECT * FROM 06JobSchedule" rs.Open sqlstr, Cnxn, adOpenStatic, adLockReadOnly, adCmdText Why these statements gets an error( 06JobSchedule is a quey). And if change 06JobSchedule by Shedule(which is a table), it works! Is it to say that I cannot select on queries and only in...

Wow!!!!! Way more that I was hoping for! Thanks I really like this forum and I hope that one day I will be able to help as much as I have been helped over here!!! (I am kind of a guru in SAP, but, as you can see, a nulity in VBA)!!!

Hi, I have a list box for wich the the source is a value list. I am not seeing any property that can give me the selected values. The only property I see that ressembles is th source properties which consist of a string with all values concatenated and separated by semi columns, which is not...

Hi, I am looking for a way to properly initialize unbound field. The problem is that it keeps the previous values when I go to next record. I think the problem is that I put my initialisation coding in the form's load event which occurs only once when opening the form. I guess that if I could...

I have one invoice table and one invoice item table. It is on those two table that I did a query. The query is group by invoice number and sumed up on the item amout(to get the total amout). It is on that quey that I based my tabular form. Each line on the tabular looks like: Invoice# ...

Half a success. Now I know why it was read only. But here is what I am trying to do unsuccessfully: I have invoices and of course, invoice lines. I need a form(tabular) on which each line is an invoice and one of the fields is the total amount. To have that total, I need to base my form on a...

Bingo!!! Thanks

Hi, I just created another query, but with this one I cannot change any of the data. What could be the reason? Thanks

Ok, I will try me.refresh and give news on that Thanks

I am running an ADP connecting to an sqlserver database on a remote web hosting service

Hi, We have 1000 contracts to update information in. I have a contract form that 2 users use simultaneously to do so. The problem is that each users can modify a record, go to the next one, come back and see that his changes are still there but if user B happens to cycle through one of the...

Do you know of any knows list that contains cross-refs of all Countries,state/province,region so that I can build cascading combox for my site. This is very strange. It is a concept we see all over the internet websites, but the least documented!!!!

Access documentation talks about the Required Property that allows to make a field mandatory on a form. But I don't see it anywhere in the list of properties. I think might be because it is not applicable with sql server (in a ADP). In that case, how can I make it mandatory? Thanks

Hi, I just finished converting My Access database to an ADP with sql server. and runs great. But oupsss I was about to take care of all the multi-user and security aspects..... where are the sub menus that used to allow the administrator to create users right from Access and manage security? It...

But my format is Money.....

A: No conversion to text(as far as I know). A clue is that it does that for values that are calculated fields on queries. Since they only exist from the queries, I dont see any place to specify atype or a format. B: when I saw your answer, I was certain you had nailed it. But I did what you...

I had already tied that one, but the event triggered each time I save the record or go to the nest/previous one. I need an event that is triggered at the very moment a field is modified. Any idea? Thanks.

What is the best event of which object to put some code that needs to be executed every time any fields gets changed in a form. I would think it is one of the event of th form itself but not sure. Please confirm wich event and which object. Thank you

A)On a bound text box, my source has a value with a lot of decimals. I would like the text box to have only 2 decimals. 1-text box format property:currency -> does not work. 2-text box Decimal places property:2 -> does not work. B)On a bound text box, my source has no value. I would like...