Search results for query: *

Thank you for replying, it seems there is a choice here as with all computer solutions Do you get a reasonable response time with this MYSQL and Dreamweaver configuration. Also on Dreamweaver, is that the new release?

Hello Daniel. Thank you for replying to me. Please forgive me but I'm not too hot on the communications aspect of systems design. Could you please give a further explantion of what you mean by IIS and ASP Thank you Snowy

Hello, can anybody help me. I have an ACCESS 2002 database that resides on my company's server and it's being used by three members of staff. Now it needs to be used at another company office. They both have their own servers. When it comes to adding records etc. how do the sites stay up to...

Hello all Does anyone know how to run a report from a selection screen that allows either one customer to be selected or all customers to be selected. I have a drop down list for the customer name and also a check button that says all customers. My problem occurs when I try to run the query...

I have two tables in my database and they are set up as a one to many relationship. The parent is a machine table which stores basic information about the companies machine's. The child is a service job table which has a list of jobs that have been carried out on that machine. The machines...

Thank you for these suggestions on how to get over the response times problem. I will try splitting the database as suggested and see if this will speed up the adsl link. How would I find unwanted VB code that may be hanging around in the database and does this make any difference to...

Has anybody had problems with the speed of their database from using it on a laptop. I have written a form based database and it has just started to be tested on a remote laptop using a 56k modem and VPN link to our server at head office. The response times are very slow (from a couple of...

NZ Function? I have created a query to count how many records i have that meets a certain criteria. I have then created a report to look at this query, however, i am finding that if the query results in no records found i do not get a zero therefore my report does not work. I've heard of...

How do you copy data from one table in one database to another table in another database which is the same but it has new fields. I've tried an append query but it keeps coming up with validation violations stopping it from copying. I've tried just one field and it still does not copy.

Does anybody know the insert into statement in SQL that will copy a record from one file to another if the primary key value is known on an open form. At the moment I have INSERT INTO [kpi copy] SELECT * FROM kpi WHERE [id]=827; This does not take me far enough to be able to copy a record...

Yes thanks for that. Of course if the user selects who they are in a form the next user to go in to that form will overwrite what the previous user had! Good thinking batman! All I need to do now is learn VB ! Thanks again much appreciated

Hi. I'm thinking of putting the users network id into a database so it can be used as a basic piece of information. Does anybody know how to pick up the current Network ID and place it in an access database. This would then be used as a default user when retreiving records from tables etc...

Please help, I have the following message appearing on my database, then none of the buttons or anything VB related works. The expression On Click you entered as the event property setting produced the following error. Error accessing file. Network connection may have been lost. *The...

The code behind the button looks like this Private Sub Duplicate_Click() On Error GoTo Err_Duplicate_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70...

Using Access 2000, I have been trying to duplicate a record using a button designed through wizard to copy and paste a record onto the table. I have recently changed the dates on my table to short date with an input mask. The duplicate no longer works and it says 'The command Pase/Append...

Hello everybody, I have a report (8.5) that uses SQL server view as source. It uses all its fields, plus a huge number of formulas. Rewriting it or editing all formulas by hand would be very bad idea... Since then, view has been rewritten, adding more fields. Now I need to use these fields...