Search results for query: *

I have an append query which I am trying to implement as part of a loop, so I don't have to write 10 or more different Append Queries and load them as necessary. Now I have tried this several way, and I'm not having much success. My first attempt is below.... ''put into variables...

Basically I have a search, and depending on what you search by, you can print of a number of reports. Now, I wanted to bring up a print dialogue box, so that you can select which printer you print to, but I have a problem. Basically I can be printing up to five reports sequentially, and of...

Hey, This problem has me baffled. In a textbox, which is bound I display a price per share. I have set the format to currency, and everything displays fine. But in code I am trying to copy the value exactly as it is displayed in the textbox. Now I have tried the following methods. The value...

I have this code which I have adapted from the microsoft website, basically this should put all the tables names in one listbox and all field names in another. The table names work but the Field names doesn,t. I'm not quite sure what I'm doing wrong, the code doesn't error, but when I put the...

I'm using Windows XP on a Windows 2003 server, if I hold down Alt Gr and an Arrow Key (any direction), the screen changes dependant on which arrow I press, I don't have XP at home so I can't test this any other way, does this happen on all XP machines? is it an Easter Egg? (one of those non...

Hey, I am using the Auto Resize MDE file supplied by Getz, Litwin, and Gilbert (Sybex). Now I have entered the code onto my forms as necessary, and it works great. Apart from on 1 form. Basically this for has a subform. Now the sub form does not contain the resize code just the parent. When I...

Hey, (This is an office 2000 database built using Access XP, on a Windows XP system) How do I get the Domain Name from a Windows 98 computer on a Server. I have tried many different functions available on the net including, Set net = CreateObject("Wscript.Network") sDomain =...

Hey, This is based on my last post but a slightly different problem. I have developed an application in Access XP Developer's Edition on a Windows XP operating system, I have run the developer wizard to create the run time version. The application works fine on the development PC, and also on...

I have developed an application in Access XP Developer's Edition on a Windows XP operating system, I have run the developer wizard to create the run time version. The application works fine on the development PC, and also on several other systems containing Windows XP operating system and office...

Hey, Basically the code below, should first create a database and then copy the tables from one database to another. At the moment I am using another access database file to perform this task, (I would code it in VB, but we don't currently own a version). This code works a treat if you copy the...

Hey, I have a Parent Form which provides a searching function for Time Sheet Entries, and a sub form where I can add a Time Sheet Entry. Basically if a user enters a new Time Sheet Entry into the subform, then they can save this entry. If the user exits the program via my command button (there...

Hey, I have an Excel workbook, and on one sheet there is a drop down box, in this drop down box is a list of ID's as declared in the second worksheet. Then using the lookup function depending on the ID entered, the remaining cells in that row enter the data relevant to the ID in sheet 2. This...

Hey, Basically when a user enters a WorkRequestNumber in one text box this should automatically load the SalesOrderNumber into another textbox. As of yet I could not get this working. If anyone knows how to do this I'd be very grateful. As an alternative I have created An SQL Query. When the...

Hey, Basically I have built an automated Audit program, and part of this program lists every program in the uninstall directory held in the registry, along with the Version and Date. A problem is that the date is returned as 20030911. What I would like to do is take this date and put the first...

Hey, I've adapted this WMI script from the Script Center on Microsoft's site. the code itself works fine, but this picks up all drives including A: and E: (my floppy and CDROM), as there is not always a disk in these drives it comes up with the error, Run Time Error '71' Disk Not Ready, so I...

This code below checks the windows password (from the Id already obtained). I wrote this code in Access 2000, but have since been given a new computer with Windows XP Office. All my other code works, but with this code I get the following error, Can't Find DLL entry point WNetVerifyPasswordA in...

Hey, I have been asked if it is possible to list all the applications that are installed on a computer? I know they are listed in the Add/Remove Programs Section, but this is part of an audit program, that involves network connections for each user, all the users on a network and other such...

Hey, I was just wondering how you might obtain the current network User's username, I have an example for an application but not for the network... e.g ... Application.CurrentUser Thanks for any help Sam "You couldn't fool your mother on the foolingest day of your life if you had...

Okie dokie here I go, I have a form linked to one table, pretty simple stuff. Now what i want to do is to add a last edited date to the record. I have a last edited field in my database, And a textbox for which to view it. The textbox is locked and disabled, and so I don't want to have to...

Hey, I'm using an access 2000 database, and am currently creating a form that searches for any records that meet the search criteria. This all works fine. The problem I'm having is once the relevant records details are placed in a list box, I want to be able to double click the list box on the...