Search results

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...

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...

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

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...

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...

Hi, Since I upsized my Access database to SQL server. One vital statement is not working anymore: Private Sub Form_Load() Set db = CurrentDb Set rs = db.OpenRecordset("Select * FROM TimeDot where ID = " & EmployeeID) End Sub The statement: Set rs = db.Open......... returns following error...

Hi, I am finishing an Access database for a customer that may want, in a later stage, to have a website(probably ASP) that would connect on the same database. Is that possible? I mean can an Access project on a pc connect to remote database(mdb or SQL server) used by the website? If so can you...

Hi, Given this table(Meetings) EmployeeID Date Hour (Discreet values like: 0900,0945,1030,..... contained in a linked table) In my Mettings entry form, I would like to program a popup in the Hour field to show the available hours(not already taken) for the current employee. Can you give me...