Search results

When I look under my name, I get a red rectangle that indicates "Shameless Behaviour" what does that mean and how can I remove it?

I have a script that changes country codes into numbers. The issue that I am having at the moment is when I have a cell that contains other words other than the country it changes it too. Also I cannot specify the name of the colum since every excell spreadsheet is different. Example: cell 1...

ok, then I have a question. I have a form currently to register students. Which puts the data directly into the table. But due to sertain circumferences I need to have an option to choose if the student is a guest or not. I do not want to add an extra field to that table to I have created...

nice, great link, I love it. Thx.

ok, what happends is for one language the date standard is month-day-year, for the other is the day-month-year. and even that I directly mention the date format I am still having people that mix them up and when ever there is an issue I am getting bugged. It just got to the point that I need to...

hmm, I could try that. For now I just have to make the project working. Most likely when I will get to that and get stuck I will see what can be done then. Thx.

mde file prevent any changes to forms,queries, reports or vb code. (in terms of design) . so I would like to erase all of the data in tables upon the closure of mde file.

when I create an mde file, is there a way to disable it to save any changes to db. For example when users opened an mde file, he can do what ever he needs to do, but when he closes the mde all of the changes done to the database are reverted back to zero.

I would like to work on the form with more than one table without having to use a subform. I remember there was an option to have field list of more than one table. Because I need to add a field to a form that has 'one to many' relationship between two tables so that I dont want to modify...

I have a form that has a sub-form, -if I use "Forms![formUsers]![id]" to get the hold of the id value of the form. then for the sub form "Forms![formUsersSubForm]![id]" would that work? -I would like to make a continues form for product list, to make it easier to go though products. If I add a...

Looks nice, allthough, it is hard for me to avoid not using it, when I used just a date field, I had french people enter the date one way and english enter it another way, and in the end it was all the mess. And when it came to do reports I had check to make sure the dates were in correct...

I would like to add a button, that on click it would open a mini calendar with current date, where if I need to change the date I could and then I could click ok and it would set the date in the proper field.

thx, it worked, You're The Best!!!!

how do I do that?

that should not matter if I am doing a queurry and only passing the id of the form

edit: I found out that I cannot have a form and a report accessing the table at the same time, what can I do about it if I want to preview current selected record? I have been having trouble to create a form with a subform, which after you click a button and it would load up the data of that...

Private Sub Command15_Click() On Error GoTo Err_Command15_Click Dim stDocName As String stDocName = "rptlUserInfo" DoCmd.OpenReport stDocName, acPreview Exit_Command15_Click: Exit Sub Err_Command15_Click: MsgBox Err.Description Resume Exit_Command15_Click End Sub...

I have created a form, and added a button that would display the current record. When I click on the button I get "database engine could not lock table..." When I launch the report by it self, it open, but doesnt want to open through form button.

ok , i'll try that. thx

oh well, microsoft screwd us over!