Search results for query: *

The set up is to develop as much as possible in ms access front-end. To avoid possible performance trouble (slow-running) to store the data in SQL SERVER, also to let open scale possibilities for the future. Just one question for the moment. Can you link from the front-end ms access as easy to...

Ok. I just looked up a classical course of Microsoft SQL SERVER. What level or knowledge is required as it should function as a back-end ms access database ? If I only construct my tables in ms SQL SERVER and run my queries (+ reports, forms) in ms access front-end. Or is it recommended to run...

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 need to check if there is a record, an empty record requires no action. PHV, one your action he is complaining and on my code trial below also. What is missing ? If IsNull(Forms!F01_ORDER!FS_T02_ORDER) Then Else DoCmd.SetWarnings False DoCmd.RunCommand acCmdDeleteRecord DoCmd.SetWarnings...

don't know what you mean and how to ?

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

oeps, I made a mistake putting it in the general vba ms, sorry

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.

For this application I while use a simple solution (a bit against the idea to avoid redundancy). I will simple copy my report and set a different recordsource for each. With a if statement the print button on my form can switch between the two.

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 mean need to convert to 2007

didn't know it, wrote my application in Access 2000, but need to be converted to Access 2000. So this save me time. I can google but if you have a good url, its welcome.

sorry, found a thread of the theAceMan1. If a have further questions I come back.

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