Search results for query: *

Hi all, From Windows, I have made an SSH connection to my centos vps server. I use Putty to connect and using the public key on the server and private key on my local machine I the connection is made. I have to enter a passphrase every time I connect in this way. As I understand it...

Hi All, A strange thing just happened. I created a query that joins a few tables together and when designing it, it returned a set of 176 records. When I saved the query and opened the saved query again, it returned 0 records. The design view still looks exactly the same and the SQL looks...

Hi All, I'm trying to assign a value returned by a custom vba function to a textbox on a report. The function uses two parameters that are passes from the call in the textbox. I tried setting the textbox value to: =Bedrag(0, "Deelgebied_1") or something similar. I have around forty different...

Hi All, I'm having some trouble with this SELECT INTO-query query I'm trying to build. This query (Query 1) gives the error statement: "Query input must contain at least one table or query."(Error 3067) Query1:SELECT tblGWS_Alle_data_tmp.BhId, [Top_Drijflaag_NAP]-[GWS_NAP] AS DikteDrijflaag...

Hi All, When I am adding a new record in the form, I want to make a tab visible as soon as the autonumber field in this record gets a value (i.e. after a value has been added to any other field in the form >> the autonumber field is disabled). Is there an event that is triggered that I can use...

Hi All, I am creating a form for editing and adding data in an access 2007 database. I have a problem with a subform turning invisible if there are no records in it for the current record in the main form. I'll first describe the part of the database in which the issue occurs: The database...

Hi all, I'm having trouble on a database I have. When running an append query on a linked table with an autonumbering field, I get a key conflict. This has been noted by others. It seems that when a table is linked, Access converts the autonumber field to a number field. This prohibits running...

Hi All, I'm trying to automate some routine work I have to do. I often have to copy-paste map images from Internet Explorer to Word and then resize/ position them. I have recorded and edited a macro that should do just what I want. Here's the code: Sub PasteAndScaleMap() ' ' Paste and Scale...