Search results for query: *

Hello: I have a bunch of word Files in the folder: "C:\Documents and Settings\user1\My Documents\Project" I have named each excel file with the "project name as the prefix". Say the project was "Finland". Then I'd have files Finland-Jan Report.doc Finland-Project Mid Report.doc...

Hi, Is there a way to define a global macros? I mean I have a macro in one excel file. However, I want to run that macro from another file. I could copy the code into the new file and run it. But that is tedious. I could also open the file that contains that macro and then run it from the new...

Hi: I am just starting with excel macros - so bear with me. How do I pass a variable to reference rows. for example I have Dim Last1 As Integer Last1 = 12 Rows("1:Last1").RowHeight = 15 But it gives an error in the Rows("1:Last") ..... RiderJon "I might have created...

Hi all, I use Me.Requery to refresh a form's data. But every time I click the refresh button, it jumps to the first record. I could store the "primary key" before Me.Requery and do a Me.Filter by the "primary key". But I was wondering if the jumping to first record was by design or something...

I have a database polling info from an ODBC connect. The ODBC tables open fine when I double-click on it. However, when I try to run a qry from it, it fails. This same query was working fine for a long time. By the way, this query is set-up by linking 4 ODBC tables. Any suggestions? Thank...

Hi, I have a form that pulls data from a table. Easy. But when I modify data from the form, it does not get updated on the table. I have tried clicking on the write button (the left bar) before logging out. Funny part is that it was working just a few days ago. pls. let me know what I...

Hello All: I couldn't find a way to solve this using normal forms so was wondering if there was some VBA coding that might do it. Using the pivot table/chart wizard I created a Pivot Table that looks like Project1 Project2 January Februrary 1...

Hello all, Please help. I know this isn't the right page to post my question. But I did try posting in MS Forms without a single respose. Hello, I am trying to create a pivot chart with "Months as the x-axis, and count at the y-axis. (new to chart stuff - so bear with me) I have the pivot...

Hello, I am trying to create a pivot chart with "Months as the x-axis, and count at the y-axis. (new to chart stuff - so bear with me) I have the pivot table set-up fine except it truncated the x-axis if data are not present. 1) Meaning if the count of ppl for January is 0, the x-axis begins...

Hello, Is there a way to create charts in ACCESS using some fields in ACCESS. By charts, I mean bar/lines/pie graphs like in excel. If not is there any other ways? Thank you RiderJon "I might have created ctrl+alt+del, But Bill made it famous" - Dr. Dave

Hello, I have a table with just one field. Using the "on click" button I want to replace the first row with today's date/time. I have the code to add the date to the table. using db1.AddNew (see code below). But I don't want the table to grow, I just want the first row data to be...

Hello all, I am trying to refresh form data. But it doesn't work Since my record source for the main form, frmMain, is a "group by" query & a table, tbl1, I cannot update tbl1. So, I have a command button on this main form, frmMain, that opens another form, frm2, which allows me to...

Hello all, I have been using VBA and ACCESS to create databases and link tables between them. Now, I need to deal with a ODBC type. I have no idea how it works: for example, when I double click on the "green" ODBC link, it does not display the data as would a linked table. My...

Hello, Can anyone please tell me a good 3rd party software to Restore Registry from an image on Startup. I found quite a few that restore with an user GUI. However, I'd like the ability to save an image and on start-up to run the program automatically to restore the registry back to that...

Hello all: I am trying to repair my XP Home - OEM installed. I know the admin password. When I try repairing using the XP CD by hitting hit "R" and then typing "1" for C:/windows. It says me for an "administrator" password. When I enter the password, it says it's...

Hello all, How can I restrict an user (with limited access) in XP pro from moving desktops icons. I want those icons to be fixed in place and unmoveable. I don't want to use a 3rd party software like PC-R dist to copy images each time. Thank you RiderJon "I might have created...

Hi: I have 2 questions about restricting a user's (with limited access or otherwise) ability to do certain things. It has XP pro. Question 1: For a lab user, I am trying to restrict the ability to access C: drive by using internet explorer and typing "C:". Is that possible...

Hello all, The questions is about setting up computers with XP pro in a lab: Is it possible to allow users to just save on a particular folder, say "Temp Files" and NOT on desktop or anywhere else? Also, is it possible to enable/disable the desktop - i.e. hide the items in the...

Hello All, When I export a report from ACCESS to WORD (etc) or publish it with WORD/EXCEL, the formatting gets screwed up: Either extra spaces (and a lot of them) appears between texts (i.e. between each text boxes of the report) or the some starting line is "tabbed" more than...

Hello all, I am a SSH user, and am just setting up my MS Outlook for the first time to check emails. I can send/receive emails fine. but when I click on the "TO" to add names from my "Contact folder", I get an error message about "LDAP Directory Server (18)". Do...