| News Index | first | prev | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | next | last |
| Database Size out of control (by Kentucky5 on 11 May 2004, 3 replies) |
|---|
|
I have one database that I have multiple pass through queries to pull data in, that is not really the database that I have the issue with although the size of that database is still big considering what it contains. ... (more) |
| Calendar Control Default Value (by Alex on 11 May 2004, 6 replies) |
|---|
|
Hi, I am using OfficeXP. Trying on open form event (the calendar is on it) have ... (more) |
| Choose random records from table (by hcj on 11 May 2004, 1 reply) |
|---|
|
1. Build a query to pull records. Add a field to the query like Randstring: =mid([textfield],M,N), where [textfield] is one of the fields you're pulling, M=some starting character position, and N= some ending character position. ... (more) |
| Filter by User? (by Oli on 11 May 2004, 1 reply) |
|---|
|
Hi I have several users of a split database - which is stored on a remote server. Now we have identified the need to not let all users get to each ... (more) |
| replication question (by ^Halibut^ on 11 May 2004, 1 reply) |
|---|
|
i have a Access 2k DB that is password protected. is there a way to set up replication? i need to keep the DB secure since the data is confidential and i have some mobile users that would benefit from replication. ... (more) |
| Re-linking database through code (by John on 11 May 2004, 1 reply) |
|---|
|
Hi I have a front/back end scenario for my access app. I need to allow user to connect the front end to one of two back ends at start time. Presumably this ... (more) |
| PivotCharts and data labels (by Colonel Angus on 11 May 2004, no replies) |
|---|
|
In the PivotChart view of a query, how do I get each bar's value to display above the bar (or within the bar)? ... (more) |
| Chart title from query parameter?? (by Colonel Angus on 11 May 2004, no replies) |
|---|
|
Can I get the value of a query parameter into my PivotChart title? I'm not displaying the chart on a form or report, it's just a query with PivotChart view. Using Access 2002. ... (more) |
| Update two databases across internet (by Evan McCutchen on 11 May 2004, 1 reply) |
|---|
|
Hello everyone, My company is just opening up a new office in europe and we need to have our access database available for them to update daily just as we do. One way ... (more) |
| How many users can connect to access? (by Guy Cohen on 11 May 2004, 13 replies) |
|---|
|
Hi all, In the past I wrote a program that served 4 persons. The client wants to use the program all over the company... 10*X users. If (users<=this) then ... (more) |
| HOW TO LIMITATE NUMBER OF THE RECORDS IN A TABLE ? (by Chris on 11 May 2004, 2 replies) |
|---|
|
I need to limitate the number or the records introduced by a certain user in a table at a time ( let's say to 7) . Can it be done? How? ... (more) |
| auto insert date/time (by Rick B on 11 May 2004, 1 reply) |
|---|
|
One which will show the present date and time whenever a record is modified and also add this date to the record itself One which will insert the present date and time whenever a record is created and also add this date to the record itself ... (more) |
| Cannot insert records to Access with FP (by xfile on 11 May 2004, no replies) |
|---|
|
I use FP 2003 to come up a form for registration purpose. I first inserted the "Form" and the all text boxes for information needed, and used Form Properties to create a database and connection. Checked the ... (more) |
| Newbie question record deletion (by jmk on 11 May 2004, 2 replies) |
|---|
|
Running a program that archives files and rmoves the information from th mdb file, however after completion the .mdb file does not decrease in size?? Opened the .mdb file in access and deleted 10,000 records from 30,000 ... (more) |
| 255 Characters? Is that all there is??? (by Warhawk on 11 May 2004, 2 replies) |
|---|
|
I would like a textbox to accept much more that 255 characters. Is there any way to do that? Thanks in advance! -Mark O'Brien ... (more) |
| deneme (by .. on 11 May 2004, no replies) |
|---|
| deneme amaçlý ... (more) |
| having a problem with my form (by skylinekiller on 11 May 2004, 2 replies) |
|---|
|
I have a database which is used to match the vehicle service manuals with the vehicle. On the form I have a box fore YEAR/MAKE/MODEL: When I input this information, it doesn't save in the database, I need to get this fixed. Can I please email this to someone and have them look ... (more) |
| getting rid of helpbox on menubar (by Silvester on 11 May 2004, 4 replies) |
|---|
|
In A2002 and A2003 the 'Type a question for help' helpbox appears on the top right of the menu bar even if you use custom menus. I hide all toolbars on startup using the autoexec macro. ... (more) |
| from dbf to access 2000 (by L. T. Portella on 11 May 2004, 2 replies) |
|---|
|
I have a database in dbf and I want to save it as a table in Access 2000. How do I do it? Thank you ... (more) |
| °ê¤º¿W®a¥»ù¾÷²¼,®ÈÀ],°s©±. (by }¨È®ÈªÀ on 12 May 2004, no replies) |
|---|
|
¯u¥¿¥»ù,¥þ°ê¦U¤j«°¥«,¥ýq²¼,¾÷³õ¥X²¼. °s©±¥´3§é°_,¥t¥Nq¥þ°ê¤õ¨®²¼. ... (more) |
| 2nd attempt - HELP! - Formatting does not appear in subreport (by Ivan Starr on 12 May 2004, no replies) |
|---|
|
Hello, thanks for helping. I have a subreport/subform control in a report that refers to another report designed just ... (more) |
| exe in MS ACCESS (by Prudhvi Reddy on 12 May 2004, 1 reply) |
|---|
|
Hi Can we create an exe in MS ACCESS just as we do in Visual Basic. Is mdx similar to an exe ???? ... (more) |
| Access 2000 \ 2002 (by Sarah on 12 May 2004, 2 replies) |
|---|
| Can access 2000 read databases created in access 2002? ... (more) |
| Is This Possible With Forms (by Wendy L on 12 May 2004, 6 replies) |
|---|
|
Windows XP Office XP I have something I wish to do within an Access database and I am not sure if ... (more) |
| 2000 format in Access 2003 (by =?Utf-8?B?QWxsZXk=?= on 12 May 2004, 3 replies) |
|---|
|
Hi, I have databases developed in Access 2000. Last week, my computer has been installed Access 2003 by someone else in the company. Now everytime when I opened my old access files in Access 2003. It give me some warning message like this: This file may not be safe if contains code that was intended to harm your computer. Do you want to open this file or cancel the operation? I always choose "Open" to get into my database since there is nothing wrong after that... Should I keep doing this or did I miss something here? ... (more) |
| Access Front End (by =?Utf-8?B?V0MgTG8=?= on 12 May 2004, 5 replies) |
|---|
|
I have split my application to FE and BE. The BE (database) is sitting in a file server while FE will be local LAN users or VPN remote users. I have 3 questions. 1. Is there any problem for VPN remote users connecting to the database? ... (more) |
| front size (by =?Utf-8?B?ZG9jc21n?= on 12 May 2004, no replies) |
|---|
| Since installing the new office service pack, my published font size is always small on my website, even thoush if I designed in a large size font. How can I fix this problem? ... (more) |
| Future of MS Access (by =?Utf-8?B?Sm9zaHVh?= on 12 May 2004, 5 replies) |
|---|
| I heard that Microsoft is "trying to discontinue" MS Access. Does any MVP know the details? ... (more) |
| outlook sync with ipaq / email (by =?Utf-8?B?Z3JlZyBm?= on 12 May 2004, 1 reply) |
|---|
| when I sync with my ipaq everything goes except for my email in outlook please advise ... (more) |
| Stopping Multiple Instances (by =?Utf-8?B?U0NITllERVM=?= on 12 May 2004, 3 replies) |
|---|
| My 50 or so access users feel it necessary to have the same database open several times on their PC. I feel this is causing instability to this database, please correct me if I'm wrong. Is there a way I can prevent that linked database to be open more than once at the same time? ... (more) |
| Logging in and Windows (by =?Utf-8?B?U0NITllERVM=?= on 12 May 2004, 2 replies) |
|---|
| SQL Server can utilize Windows Authentication, great terrific, blah blah, however, is there any way to set up access to automatically log in with your current windows 2000 log in. I'm guessing no, but why not throw the question to the experts. ... (more) |
| linking fields (by sonta on 12 May 2004, 2 replies) |
|---|
|
I have a form ( frmInv )that has various fields and the data source for this form comes from a table ( Tbl A) . Two fields that are present in this form are Suburb (combo box) and Postcode (text box). ... (more) |
| Re: Choose random records from table (by Allen Browne on 12 May 2004, 2 replies) |
|---|
|
You need some kind of numeric field that changes from row to row. Perhaps one of your date fields would do. 1. Create a query into this table. ... (more) |
| Record Locking (by =?Utf-8?B?Q2hyaXM=?= on 12 May 2004, 6 replies) |
|---|
| I am new to MS Access. I have read a lot of books of Access but none of them mention deeply about record locking or table locking. I wonder will Access handles all lockings with mulit users. ... (more) |
| left() (by =?Utf-8?B?Sk1vcnJlbGw=?= on 12 May 2004, 3 replies) |
|---|
|
I've seen it here before but can't find it now. How do I take a string and find all the characters to the left of a comma? e.g., 3459,fred would return just the 3459 ... (more) |
| ms access merge tables (by =?Utf-8?B?Y3JhaWc=?= on 12 May 2004, 2 replies) |
|---|
| Is there any way to merge two tables with same fields but overlapping records? I tried copy and pasting but am getting error messages I think because duplicate autonumbering between tables has created problems. ... (more) |
| Inventory and Order Entry (by =?Utf-8?B?VHlsZXI=?= on 12 May 2004, 1 reply) |
|---|
|
Hello! I am just trying to figure out a way to run order entry and inventory control together as one program, so when i sale a product using a order entry to print a order it automatically removes that product from inventory control. Ive been having to print a order using order entry and having to go back and remove that item from inventory conrol. Any suggetions would be very appreciated. Thank You! ... (more) |
| RE: Office 2003 find and replace defaults (by =?Utf-8?B?c2Ft?= on 12 May 2004, no replies) |
|---|
| I have the same question. HELP! ... (more) |
| Access 2000 VBA Help (by =?Utf-8?B?S2F0ZU0=?= on 12 May 2004, 3 replies) |
|---|
|
I am using Access 2000 SR-3 and my VBA help file is only partially functional. Many topics listed seem to have no link and some links lock my machine for a few seconds while they 'find' themselves. I found a couple of references to a fix but I can't find the fix. I have repaired my office installation a couple of times but no change. Any help would be greatly appreciated. ... (more) |
| What does MVP mean? (by =?Utf-8?B?UGFuZ28=?= on 12 May 2004, 3 replies) |
|---|
| Sorry for such a question but, what does the word MVP stand for? It is not Most Valuable Player/programmer right? ... (more) |
| Number Pages in loop sequence (by =?Utf-8?B?RGF2aWQ=?= on 12 May 2004, 2 replies) |
|---|
|
I have a report that I need to have the numbers 1-7 on. It does not matter how many pages are in the report. Each page must be numbered sequentially 1-7 tnen loop, return to 1 to start the numbering process again. Any help would be greatly appreciated. ... (more) |
| Testing question (by =?Utf-8?B?65Gl6riA7J20?= on 12 May 2004, no replies) |
|---|
| Just question ... (more) |
| Insert into .... (by =?Utf-8?B?Sk1vcnJlbGw=?= on 12 May 2004, 14 replies) |
|---|
|
Is there such a syntax as INSERT DISTINCT.... in an SQL statement? insert into TblEmpLeave (LeaveDate, EmpID, SUpdateVal, AUpdateVal, leavetype) SELECT date() as newdate, SSN, saccrue, aaccrue, 'z' from tblemp ... (more) |
| Inventory Databases (by =?Utf-8?B?V1RP?= on 12 May 2004, 2 replies) |
|---|
| I run the inventory for my small business. I have just started using access to help get my inventory management from paper to electronic format. I have orders come in and product going out. I have the products names and amounts in one table. I created another table to log my daily orders. Is there any way the connect the two. Say I have an order for 2 of product A going out...When I log that into my Orders table, I want it to automatically decrese the amount of product A by two..which is in the other table. Is there anyway to link tables like that? Make sense? ... (more) |
| Numeric Field (by =?Utf-8?B?U3Vu?= on 12 May 2004, 7 replies) |
|---|
| I am trying to create a numeric field, 4 digits long. This field often has figures such as 0001, 0028, 0123 etc. However, when entered into the table, the 0's preceding the following digits are dropped and it displays for instance : 1, 28 or 123! How do I force the system in my input mask to not suppress the zero's? ... (more) |
| Random Records (by =?Utf-8?B?QWxseSBDaGFuZw==?= on 12 May 2004, 3 replies) |
|---|
|
Hi, I have a table of 13,000 records with fileds of either Date or Text type (No numeric fields). I need have choose 5000 records randomly from this table. Can anyone give me any idea of how to randomly choose 5000 records from a table? I am pretty novice here with Access but have to deal with this problem. Thanks in advance! ... (more) |
| Test Post By Graham (by Graham McCann on 12 May 2004, 1 reply) |
|---|
|
Graham McCann Sales Executive assessment 4 Ltd 01698 888888 ... (more) |
| Hyper link in messages (by Franky Solo on 12 May 2004, no replies) |
|---|
| How do I restore Hyperlink in outlook express 6SP1 ... (more) |
| Convert word files to pdf format (by xajh_dfbb on 12 May 2004, 1 reply) |
|---|
|
is there a way to convert word .doc files to .pdf format inside Access? I've got lots of word files to maintain, I want to publish them as .pdf files to a public folder. ... (more) |
| Northwind.mdb Developers' version (by JA on 12 May 2004, 1 reply) |
|---|
|
Could someone show me where to get a copy of the developers' version of the Northwind.mdb sample database? I remember I had it before. ... (more) |
| compressing database to cd (by mike on 12 May 2004, 4 replies) |
|---|
|
My access 2000 database has reached 2gb i would like to get a program to compress it so i can put it on a cd. any help would be appreciated iam a novice thanks ... (more) |
| Hyperlinks minimising (by Mick on 12 May 2004, no replies) |
|---|
|
When opening a hyperlink, Access minimises, therefore when you close link e.g. Word Doc, Access is now minimised on tool bar. How can you make Access maximise automatically when closing hyperlink. ... (more) |
| Sharing dbase on intranet / file path. Please help! (by richard.siggins@tietoenator.com on 12 May 2004, 1 reply) |
|---|
|
Hi all, I am trying to allow all the staff in my office to view and amend an access database from the company intranet. I ... (more) |
| Hyperlinks -Access Minimising (by Mick on 12 May 2004, no replies) |
|---|
|
How do you prevent Access minimising when opening a hypelink from it, or how do you maximise Access automatically when closing a hyperlink. ... (more) |
| Access Error! (by tsmith on 12 May 2004, 7 replies) |
|---|
|
I am the Systems Admin here for my company. On Thurs Box Title: Access Message: Unknown ... (more) |
| Refreshig pivot table (by Benn Vosloo on 12 May 2004, no replies) |
|---|
|
I have a data base on one XP Pro pc connected to a network of XP Pro and Win 98 SE pcs. All other pcs are linked to the tables on this pc. ... (more) |
| access 2000 access xp 2002 (by antz on 12 May 2004, 1 reply) |
|---|
|
can i open a access 2002 file in access 2000? thanks ... (more) |
| Access97 Question (by Kevin Donoghue on 12 May 2004, 1 reply) |
|---|
|
When opening a database I get the followingh error unrecognized database format. Unable to repair . Used jetcom.exe but without success. Database size 500mb ... (more) |
| Northwind.mdb solutions (by JA on 12 May 2004, 1 reply) |
|---|
|
Could someone show me where to get a copy of the Northwind.mdb solutions database? I remember I had it before. ... (more) |
| Greek character set in Access 2002 (by Danny on 12 May 2004, 1 reply) |
|---|
|
Using the Greek character set in Access 2002 I face a=20 very frustrating problem, namely words are not correctly=20 cut at the end of lines. ... (more) |
| News Index | first | prev | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | next | last |