Search results for query: *

Don't know this is the right thread. I like to link ms access front-end to an Microsoft SQL Server back-end, or at least research the possibilities. Did some google, but can't find a clear brief answer. Is ms SQL free (is ms SQL Server Express free) or what is the minimum cost of an licence ?

hello, I restarted developing and I see that the phpadmin version has a fresh new look. Have a dummy question, what is the best way to make test-queries. With the grid, writing sql statements ? I have a few tables with ID and foreign key. tblcontact - tbladdresse - tbl-zip and I like to see...

Hey, We have an application build in VB 6.0. It works but for reason of maintenance, "the end of VB", easy development, performance we like to transfer this to ms access 2007. One of the issues is : the application reads data from peripherals (machines, furnace, ...). This can be done in VB...

Access version 2007. How many users can use the same database in an Intranet without performance problems ? Probably 20 to 30 users will use the database. How does this work. Do you have one application accessed by all the users simultaneous ? Or do you replicate the data ?

I have a delete command on each row of a subform. It works fine. If the users clicks an empty row access giving an error dialog box to say that he can not delete an empty row. How can I say, if it is a empty row do nothing and do not show an error dialog box (docmd.setwarnings false ?)...

I have a delete command on each row of a subform. It works fine. If the users clicks an empty row access giving an error dialog box to say that he can not delete an empty row. How can I say, if it is a empty row do nothing and do not show an error dialog box (docmd.setwarnings false ?)...

Don't know why Access is complaining to about the RecordSource Reference. It works fine in Access 2000 but transfering it to Access 2007 he is complaining. What to do about it ? Forms!F01_ORDER![FS_T02_ORDER].Form.RecordSource = "QS_T02_ORDER"

I like a button with the same function as the delete button on your keybord or otherwise a function to delete the row that is selected in my subform automatically

For my application I have 2 printers. 3 buttons go, print to a regular A4 printer and 1 button print to a label printer. Both printer are connected with USB on the portable. How can I fix with vba the printer of choice ? Button 1, 2, 3 print to A4 Printer Button 4 print to Label Machine.

I have a report, it should change the recordsource (query) depending on a change button if on (true). Below code is not working 100% Because he said the name of the report is not correct spelled. What is the good way to change recordsource of a report ? DoCmd.OpenReport "R01_ETIKET"...

I found a lot of stuff of alternate row colors in report. I need one for my order form. Does that exist ?

I have a form with a lot of buttons. A few text fields are not feed by a query or table but with the value of a button. However one textfield is dependent of a value of the table. "Emballage" "Emballage no" I set a drop down list with get the actual value "Emballage (no). I get the value. But...

Perhaps a basic logical thinking question. Code below is working (fine), I create buttons on a form in rows of then. I mean this is working fine if I have 10, 20 or a few more buttons. If I have 30 or 40 buttons, he set the first 10 correct, the 20 next also correct under the 10, but more then...

sorry, I can't get out. I have a number of buttons, they can be numbered like btn1, btn2, btn3, btn15, ... With the event OnClick on a button is a macro activated that run a procedure, this is a function. testfunct(btn1.caption) Function testfunct(ctl As String) Forms![14]!txtIDART = ctl...

I create my buttons and forms with vba. I wonder if you can even add an event and some code on it ? OwnControl.Caption = rst!plantnl OwnControl.ForeColor = white = not working. OwnControl.Name = rst!IDPL

I have a number of buttons on my form. If I click one, the name (a number) should apear in a textbox in the same form.

I was searching a while but could not find an aswer close to my I think its an relatieve easy question. I have a table of 15 items. In time these can change a bit (15 to 20). To avoid that the user should add new buttons manuallyu he should run a little procedure to create for him the buttons...

Is there an easy way with vba to say next ... I have a subform menu where every next new record has besides textboxes a combobox. Every next record combobox menu should show first the previous selection. Eg. In the first record dropdown the user select "Bread". The second record dropdownbox...

Hey, I have 2 comboboxes. In every new form screen (order input) these are empthy. Important, the second comboboxes kan only be activated if there is a value or a selection made in the first combobox. I tried something but does not 100% the job. if (IsNull([combobox1].value) then...

I compose an emaillist, quotes are required. I am struggling to put quotes around every email address. Syntax problem. <?php while($data = postgressql_fetch_array($result)) { $to = ($nrto <> $count_rows ? $data['Eemail']",": $data['Eemail']); $nrto = $nrto + 1...