Search results

Hi, I have an access database which is used to run a procedure and extract and manipulate large datasets for a linked SQL Server table and spit out excel files for my work. It runs overnight, and last run bloated to a file size of 2,097,063kb. Now I cannot open to compact and repair as I get a...

Hi, I have a large questionaire table. One column has yes/no/na as options. I was testing it and set some records to NA then went through and deleted the NA. Now I have a query --> Select * From Table where answer not = "NA". This query is leaving out the records where I had NA and then...

Greetings and Salutations, Access 2003. I have subform who's datasource is a query. I have a button on the parent form that deletes the query def and recreates it. THis all works fine, but the new query definition is not displayed in the subform (even though the datasource query has changed)...

Greetings and Salutations, I have built a questionaire database. I wish to use it on a tablet PC to collect field data. The tablet screen is obviously much smaller than a PC screen. Is it possible to "Wrap text" (like in Excel) for table data in a subform? Otherwise the user has to scroll...

Greetings, and Merry Christmas to one and all, I use this Function to send emails through Lotus from Access 2003 Database. Public Function NotesMailSend(strRecipient As String, strSubj As String, strBody As String, strAttachment As String) 'StrRecipient is the email address of the recipient...

Does anyone know the VBA to make a subform the "acSelection"

Greetings, Has anyone ever used Docmd.printout to print a form? If so how do you get it to fit to 1 page? Are there properties to do this? Spent

Greetings, I have a Pivot chart form that I have embedded in another form. I want the user to be able to use the pivot chart, but not be able to right click it and add fields etc.. Any tips on how to achieve this? Spent.

Greetings, I am trying to get Lebans Mousehook to work, but it aint do .... http://www.lebans.com/mousewheelonoff.htm I have setup a test database to use the mousehook. When I click the stop mouse button it should stop the mousewheel cycling through records, but it does NOTHING. Anyone got...

Greetings Friends, I have a form when it opens the navigator is on 1 of 899 records. I have set up the following to try and prevent mousewheel: Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal Count As Long) If Count > 0 Then If Not Me.Recordset.AbsolutePosition = 0 Then...

Greetings, I have a database which is used by approx 7 people here. I do my developing in an mdb file. Then I compile to an MDE. The 7 people use the mde file to update 2 SQL server tables by ODBC. Yesterday afternoon at approx 3pm some forms in the mde when opening became very slow. This has...

How do you update your details and add a picture etc... I tried clicking on "About me" but none of the edit links work?

Greetings, Could someone please explain to me what happens (and why it is needed) when the Database is compacted and repaired. My database stores data in a seperate SQL server database, with only lookup tables in the Access database. On use for a day or so it increases in size from ~90MB to...

Greetings, I am creating an assets database. Each asset has approx 100 fields, all 1:1. Should I make one table, or try to break it down into several tables linked by Asset ID? There are no 1:M relationships, so there is no real reason to make more than 1 table. Is the massive 100 field table...

Greetings, Can someone please explain to me the difference between a continuous and a non-continuous form is? I have searched far and wide, and I think that a continuous form is just your standard form..... so what makes a form continuous? What makes a form non-continuous?????? :(

Greetings, I have an access database which has ODBC linked SQL Server tables. When I try to query any date fields it causes Access to crash. E.g: SELECT tbl_maintenance.d_CommDeadline, tbl_maintenance.d_Issued, tbl_maintenance.OBJECTID, tbl_maintenance.txt_SegmentID, tbl_maintenance.txt_Code...

Greetings. The forms in my database are popup, and maximize on resize. They cover the entire screen (menu = 1, popup, no border etc..). All navigation is done by command buttons and the like. I created a minimize button so users could minimise the application and do other work using this...

Greetings all, I have been working with Access for years, and never had this problem: If the user types (R) in a textbox, then the registered trademark symbol appears. Is their a way of turning this autoformat off for all forms in the database? Menu option or VBA code?