Search results for query: *

I have a problem. I have a fairly sizeable database, in that it's got quite a few million records. I found a few weeks ago it started timing out on some computers. Each computer has an access front end that does an "open form" and depending on the postcode that the user enters, it returns that...

I have a program that writes to a couple of files in it's own directory off C:\, let's call it programx. So I have a folder on all machines with programx installed called c:\programx\ I need to give each user under a specific OU modify access to that folder. Rather than go to each machine...

Trying to change a subform by using "sourceobject" Button works but the "subform2" is changed into datasheet view. I have changed the form so it says "no" to datasheet view, but still shows wrong. Should mention this is an upgrade from an mdb database and all was working ok with the old one...

I have a sql database that houses appointment data. I'm trying to create a report that will match up "required" appointments with actual appointments. Currently I've written a query that counts the number of appointments for each date and returns the day name (ie. "Monday", Tuesday etc..tippin...

I have a word template that when I open the actual template file, the page numbers are all ok. When I open the template so it creates a new file, as templates do, the page numbers are out of whack. In that that it take page 2 of each of the sections and use that as the page number in the TOC. If...

I have a vb code that inserts and deletes a couple of different pages then the entry for those pages into the TOC. All works ok for each page seperately, though when I use the code to insert more than one page, ie Intro then Summary page, the second insertion puts the TOC entry "inside" the...

Don't know what's going on here, one minute all was going well and I could log into the domain as Admin etc. Then the next, I come up with this error?? I can't even login directly to the server with the domain. I have to change the domain to the local comp name and login locally. and when I do...

I have a simple application form that in IE works properly, as in each time the next button is pressed a new "hidden" page is shown etc until the end of the form in which the form is submitted. The issue I have is that when the same form is looked at in firefox, the first time the next button...

I have a flash file that has a menu system that when rolled over drops down a bunch of buttons to choose another page on the site. Fairly simple in essence, but for some reason I can not get the "onclick" function working. I have the rollover all good, and that drops down the menu system but it...

Something of a strange issue, I've got a screen I am setting up in an outdoor environment. I will be having it weather proofed, but this causes a problem. That of making the casing an oven, at the moment it isn't much of an issue but it's not too hot but when the weather gets to 40oC the screen...

I've got a little subscription form on my website that calls a php script that does a few things, including writing the subscribers Name/email to a log file (text file) and the same for a referral box that is on the form, it also emails anyone that the subscriber puts in the referral box with a...

Ok. This is starting to do my head in. I am trying to automate a "single" record to a word document. I can easily do it with an mdb file, but since changing to adp/sql database I am having issues with referencing the forms clientID. I could probably make a seperate adp front end for each...

I have an issue with my mouse that when I am in Excel and I select a cell, the mouse then anchors to that cell and it's like I am holding the shift key; whereever I move the cell's get selected from ythat anchor point. Also when I try and drag something from 1 folder to another, I can select...

I've had no problem in the past merging information from an Access .mdb file but since upgrading to using a SQL back end and .adp file I can't seem to mail merge a single record, I can merge ALL the records but I need to merge just the current record. In essence what I want to do is have a...

I am having a few issues connecting a word mail merge to a dynamic table name. I have a VB script that creates a table with the name being "letter" & [ClientID] and the record inside that table referencing the Client in the main database. All good. Then I want word to open and merge from that...

I get how to export a query to excel...Not a problem. What I don't get is how I can filter that query to a single record based on a ClientID that is selected in a form. What I am ultimately trying to do is merge that information toa word document somehow. What I was going to do is export it to...

Nice and simple function in access and excel is the PMT function. I don't believe there is such a function when using SQL but I have found a workaround which calculates the same thing but I can't get it to work. Below is the supposed Mathimatical equation that will give me the right figure...

I have a script that runs everytime an email comes in, it uses "sendkeys" to send the email subject line to a telnet program. It works when there is one email, but when I recieve more than one email the script on the second email will start running before the first process is finished. So what...

I have an outlook script that runs through a rule, the script uses "SendKeys" to send data to a terminal program. My problem is that the script times out a various intervals when sending the information. Sometimes all the information will send and sometimes only about half. No error messages...

I have a db with a few tables. 1/Client Details 2/PostCodePointValues Etc. What I need is to have a query that will return a value from the PostCodes dependant on what the Clients Post code is. I have currently Opened a query with the following fields. Client Details - [PostCode]...