Threads Replies Last Post 901 Pages: <<  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  >>   Back end Front end file locations I intend to place the back end file in a shared folder on our network. When I use the database splitter wizard I also save the front end file there. Will the links still be Ok if the user moves the front end file into one of their own folders which are not shared. ... 6 19.09.2006 20:00:41 exporting to excel How can I automatically cut a database in half and export to two excel files. My database is 76,000 records and excel can only hold 65,000. Is there a way to simply cut the database in half?... 2 19.09.2006 19:51:01 Format current date Is there anything wrong with this script. I'm using it in a query. CDate: Format(Date(),"mmmyy") I keep getting the following error msg. Error msg: Wrong number of arguments. Thanks -- Gina... 3 19.09.2006 19:48:34 conversions hyperlink to text and to hyperlinks hello, I have a form requiring to read emails in text type, convert it to hyperlink and save it in another hyperlink field. Other times i need to extract the email of the hyperlink and save it in the text field. Francis ... 1 19.09.2006 19:48:17 Slow to open a shared network folder We use a MS Access Database on a shared folder network approx 13 users. Some of the workstations take a long time to actually open up. Once open, performance is fine. Any suggects?... 2 19.09.2006 19:44:01 Access 'jet database' error message I am attempting to open an access DB and am getting the following error message: 'The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.' I need to urgently get into it so that I can updated it and run a set of reports. Any suggestions/solutions would be greatfully recieved.... 2 19.09.2006 19:43:01 Why does my desktop XP not recognize my scanner The scanner is part of the HP OfficeJet. The printer function works well. The scanner stopped working when I added a 2nd printer (Epson PictureMater). The HP OfficeJet scanner works when it is hooked up to my laptop which does not have a printer. Yet when I try to scan into my desktop I get an error saying "cannot connect to computer" Please help... 4 19.09.2006 19:33:36 SQL Query for Month (Almost Complete) Thanks to some help in this NG, I have the following statement almost complete for our needs. The results of this query should show all of the fields that have an "EndingDate" of the next month. This statement works ok, except in December because the next month also is a new year which is greater than the current date (in Dec.). So any ideas how to tweak this to make it work in Dec. a... 3 19.09.2006 19:30:07 Data Access Page changes Hi, I am using Frontpage and Access 2002. I have created a data access page from a query in the online database, and it works fine. But when I modify the query (change a criterion), this change is not reflected in the data access page when I run it. Why not? Do I need to make a new data access page each time I change anything in the database? Thanks in advance, Paul... 2 19.09.2006 19:20:43 SQL error server 53 when Access database opened exact error is "Connection Failed: SQL State; (011)--SQL Error Server 53" -- Ctrl-Alt-Del signing off... 1 19.09.2006 18:56:02 "Randy" "Steve" whatever - Please read One day you will have someone that you love and care about. You might, like me, find out that one of the reasons that they died, or someone that they cared about died, was because of a deceptive email. I know you do not believe that this can happen. I lost my son Frank, aged 32, father of three beautiful children as the result of events following a deceptive email. It frightens me ... 4 19.09.2006 18:35:07 data to documents I have a database (obviously, if I'm writing here...) and I want to create a word document from certain records. The form is working, except for certain fields. I can't figure out why the VBA is allowing certain fields to be passed but balking at others. I the coding I am having trouble with: Private Sub Printform_Click() On Error GoTo Err_Printform_Click Dim wrdApp As Word.Application ... 2 19.09.2006 18:30:02 SQL Query for Month I need a SQL statement that will return all records with a month in the "Date" column that is 1 month past the current month. For example, since this is September (month 9), the query will return all records where the month is October (month 10) from the date column that is formatted as MM/DD/YYYY. I'm getting close, but I can't quite figure out how to extract only the month from the c... 5 19.09.2006 18:29:43 Q: How to find reference filename We're using Access 2003 in our office. I created a form using the filedialog method, which requires Microsoft Office 11.0 object library, which I have, but some others don't. So 1) What is the name of that file I have to add and how do I add it? 2) Tools | References tells me the name of the file, but the path is truncated and I can't see the full name of the file. How do I go about see... 2 19.09.2006 18:03:01 Debug/code window appears on startup I have an Access 2003 ap that I did some updating to last week. When I was updating it, I put a "stop" on a certain line of code so I could check the variables and make sure they were doing what I wanted. Once I got everything working the right way, I removed the stop from the line. Now, whenever I start my app, it stops on that line of code and highlights it yellow. I click the cont... 3 19.09.2006 17:30:30 reset autonumber every year automatically Can someone find a way for MS Access to reset an autonumber to 1 every financial year or everry calander year?... 2 19.09.2006 17:29:26 Can't email from outlook cc or bcc When we try to email a group of people in Microsoft Outlook, and put groups in cc or bcc, the email doesn't get sent. If I just send an email in the "To:" box, it's ok, but anything in cc or bcc and it won't work. ... 3 19.09.2006 17:20:15 Color Coding certain entries on a form/table Hello, I have an interesting issue-- I have a table that lists all schools in New York City. Some of these schools are certain types of school. When we're doing data entry, we would love for these special schools to be color coded. I've tried simple formating in the table, but this then applies to all schools, not just a certain type of school. Any ideas about how to do this? We want ... 9 19.09.2006 17:01:19 size of database Access2000...plz... helo...i want to know about something...i think u all know about this...how much the maximum size for Microsoft Access2000 database??can i load bitmap files about 38000..which are about 5gig??? plz... i need an answer...plz... thanks for any help.. ... 4 19.09.2006 17:00:19 Can't delete record I have a form which displays details of each record in text boxes. It has New, Print and Quit buttons all of which work fine. I added a delete button with the Button Wizard and made its action Delete Record. The wizard added this sub Private Sub cmdDelete_Click() On Error GoTo Err_cmdDelete_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem ac... 5 19.09.2006 16:56:05 Can anyone help me with a form issue? Please Hello I have a form which has around 100 records and I was wondering is it possible to have a wee pop up search box that I can click open and enter something in the fields to search for a record? If that makes sense. Any help would be much appreciated. Thank you Access Beginner... 3 19.09.2006 16:33:53 Career Advise from MVP's My Background: I have worked as an IT guy for over 25 years not really specializing in any aspect of it. My first Qualification was Lantastic and became A+ certified before there was a curriculum established(should bring back memory for some) However, like many of the database appliations out there I choose Access 2.0 back when DBASE, Lotus and others were competing for market share. ... 5 19.09.2006 16:21:31 I have never programmed in VBA, but ... I need help I have a form named "Flight Roster" that has a subform named EPR which has a textbox named PreviousCloseout. On the "On Enter" event of the subform I want to define an If Then statement in VBA to check to see if the date it contains is < the current date. If it is, then I will run a message box to see if the user wants to automatically update it or not. The problem I r... 3 19.09.2006 16:03:55 access file size limits Hi, Two related questions. 1) I have a non-normalized Access database which is just a very large data table, to which I add about 100,000 rows each month. This db is currently about 1 gb in size. How large can the db become before it becomes unstable? 2) Would taking the time to normalize this db reduce its size? -- Brevity is the soul of wit.... 5 19.09.2006 14:55:02 Access Reports Is there a way to have an Access report be displayed on a form? I have a master form with a subform that changes when the user makes various selections. As it is now, when the user opens a report, the report opens as a separate object on top of the form. Is there any way to display the report as a control on a form, so that the user never leaves the main form window?... 1 19.09.2006 14:49:01 901 Pages: <<  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  >>