Search results

Ok I found it out. Just posting the solution in case someone else might have the same problem. I have run the Query on the SQL Server and it shows the value as Null. Somehow Access does not show Null but 0. Strangely if I change the condition to checkValue = Null it worked like a charm and...

Hi, I have a table with a value that need to be checked via a checkbox(lets call it checkValue). The database saves this value as -1 if checked. (I have a SQL Server 2005 as Backend and the field is a bit) If I run a query to show all the records that have been checked it works fine...

I now change the Recordsource in the FormOpen Event as it is supposed to no executing the default recordsource before this event. I hope that is right.

Open Form with modified Recordset Hello, I have a split database and I would like to reduce traffic as much as possible. If I want to make a form to filter data for a main form(a so called search form). Keeping in mind that I dont want to apply the filter after the big form with 10000...

Well, I my specific case Access copies via VB some values into different Excel Sheets. Will VB adress the local Excelapplication or will it stay within the Terminal Server?

So I dont need a Access runtime license. But I will need a Windows Server Client Access License for everyone who will connect to the Terminal Server, right? What about if I call Excel to copy some data in Excel Sheets. That will definitly burst all the licensing scheme... Assume I follow the...

Thats an interesting design view. Will it implizit that I have only one accdb file? If yes does Access manage the variables for every user opening a accdb database seperatly or are the variables shared? To get Terminal Service working with Access do you need additional licenses? Can you...

Hi, as more and more people are using the database, I decided to put all the data into a SQL Server backend and give the users only the frontend(Forms and Reports with linked tables). From the Design point of view I have created queries that run on the linked tables. Forms and Reports are...

I think my error description wasn't THAT bad. Its just the longer the look at an error the clearer it come and you can describe it.

Wow! Thanks for the sokratical help (Maieutik). That was the point. I now clone the recordset and navigate through the clone. And viola I can call the procedure as often as I want. Thank you guys!

I execute the procedure that open an excel workbook to put data into the excel worksheet. If I click a second time an the button I get a lot of errormessages because the recordsets in the form and subforms are empty. I just got an idea. Can it be that I somehow change the recordset or the...

Hi, It depends on what you want to do with your value. Do you just want to show it in the form or do you want to save it into your database (what would be a bad design issue). In the first case, make a new textbox. Click on properties and go to data-->controlsource. Here you type the names of...

Update. I tried to set the focus as the very beginning of the sub Application.Forms.CustomerForm.SetFocus Application.Forms.CustomerForm.Form!QuoteForm.SetFocus Application.Forms.CustomerForm.Form!QuoteForm.Form!JobSubform.SetFocus But in the second run I can't get hold of the recordsets from...

Hi I finally found the solution to only print the selected record: Function PrintRecord() 'This procedure selects the current record and prints it. RunCommand acCmdSelectRecord DoCmd.PrintOut acSelection End Function It sets the focus to the selected record and runs the print. Hope...

I agree, that is no good to print a form - as it is not the purpose of a database to print everything. But you know how users are. Sometimes they to want to hold something physically in their hands. The differenz between forms and reports is that reports are populating a mass display of data...

Ok, here comes the complete "Spaghetti Code". I recon it might have something to do with trying to access variables via Me.Form... Maybe because I activate Excel the Me object gets changed or something. Thus if I try to execute the action again the recordset from the subsubform is empty. As...

Thank you very much for the tip. Now its setting the focus back into the form. Seems to work. As I still struggle with an inconstant state of the database as soon as an VB Error occurs I can't tell if the lose of data is related to this cause. Hope I get it stable to give more feedback.

Hi, I have a form with some controlls containg data and other implementing functionality (like save, search etc.) I would like to give the user the possibility to print the form but without the funtionality controlls as they dont provide any value to a printout. ;) Controlls with...

Hi, I have a Access 2007 form with 2 Subforms. On the main form I have a button that executes an event procedure. In this procedure I open an excel application + workbook and write some form values into the excel. The code opens the excel and the workbook and even writes the values but when I...