Sponsored Links

comp.databases.ms-access comp.databases.ms-access

Page 10 of 829

110

510

Last »

Threads in Forum : comp.databases.ms-access

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Error 3045 Could not use <db file path> File already in use I'm getting the above error message at the line 'Set db = ...' in the following code (which is called from the autoexec macro before anything... Bob Darlington	06-05-2012 02:59 AM Bob Darlington	3	42
vba to upload to sharepoint Hi All, Using Access2003 I extract some data from some tables and populate some spreadsheet templates and save them on a server/folder. Now I'd like... bobh	06-04-2012 01:55 PM bobh	2	44
Database Modeling help??? David Hare-Scott wrote: Do you see why? What do you think you would need to do to correct it? Think about what a key does: it uniquely identifies... BadnBull_Options	06-03-2012 09:27 PM David Hare-Scott	3	37
Table Macro to log edit date/time I'm having trouble getting Table Macros to work. Might be some general thing, but I'll give 2 examples: 1) Whenever any field is edited, I want... Danny J. Lesandrini	06-02-2012 03:39 PM Albert D. Kallal	4	38
Making Sure A Database Is Running ( 1 2 ) I need to run a process using a timer. The process needs to be running all day long. We are looking for a way to ensure that the program is... Neil	06-02-2012 05:47 AM Neil	12	67
Change splash screen on forward date I'm a relative newbie but have developed several Databases at our organisation. Because of a forthcoming reorganization, there is a need to change... Yvonne	06-01-2012 01:27 PM Patrick Finucane	3	39
Query that compares a fields value with the same field over last 5 days Hi, I want to writue a query that takes results of a previous query and wants to return all those with a value of 0 but where the previous last 5... colmkav	06-01-2012 08:30 AM colmkav	5	40
Designing tables to be compatible with Sharepoint Hi, I have a new project and I am thinking I might as well at least try and make the Access 2010 backend tables compatible with Sharepoint (not sure... PW	05-31-2012 05:35 PM PW	3	32
Error 5 "Invalid Code or Procedure" when using string functions I'm getting Error 5 "Invalid Code or Procedure" when I execute the following line of code: If (Left((strCutAddress), InStr(1, (strCutAddress), " ") -... Greg (codepug@gmail.com)	05-31-2012 01:42 PM Greg (codepug@gmail.com)	4	37
Scrolling subforms I have a subfom sized to show up to 16 records i.e. about 4" high and each record is about 1/4" high The subform itself can contain anything from... Phil	05-30-2012 06:36 PM Phil	5	36
Inserting OLE Object field into Oracle Blob with stored procedure Hi, I'm trying to import Ms Access 2003 data into Oracle database. One of the field is an OLE Object field with word doc into it. I'm trying to... wesley.saris@gmail.com	05-29-2012 07:18 PM Access Developer	2	36
Access10 does update the date. I upgraded from Access2003 to Access10, and I use it for my small business. When I leave the computer on all night I find the date remains the same... Peter Jason	05-27-2012 03:31 AM Phil	5	45
Placing a control on a report with VBA I have an Access report with simple bar graphs that chart percent values between 0 and 100. No problem there, I just use the following line of code... septimus	05-26-2012 02:12 PM Evan Cater	2	53
Re: attend USENET newsgroups, of which this is one, are unmoderated and have no "gatekeepers" -- this newsgroup is for technical discussion of, and questions... Access Developer	05-25-2012 03:21 PM Access Developer	0	43
Send report to individual recipients On 25/05/2012 16:28:42, Patrick Finucane wrote: Please see posts from various people whos opinion is to be... M Joomun	05-25-2012 11:34 AM Phil	6	37
please help - relate table METHOD TABLE ======= CTC ORT --------------------------- TEA GRADES TABLE ================ Lasitha	05-25-2012 10:36 AM Lasitha	2	41
please help - relate table METHOD TABLE ======= CTC ORT --------------------------- TEA GRADES TABLE ================ Lasitha	05-25-2012 12:52 AM Lasitha	2	44
please help relation table METHOD TABLE ======= METHOD CTC ORT --------------------------- TEA GRADES TABLE Lasitha	05-24-2012 10:41 PM Lasitha	0	37
please help METHOD TABLE ======= CTC ORT --------------------------- TEA GRADES TABLE ================ Lasitha	05-24-2012 10:30 PM Lasitha	0	40
Re: * * * OnTimer event may be the cause of your pain! * * * On Fri, 18 May 2012 20:44:31 -0700 (PDT), pemigh <pemigh (AT) gmail (DOT) com> wrote: The timer event can certainly cause problems while us... Tony Toews	05-24-2012 03:45 PM Access Developer	5	40
SQL extra filtering query Hi, I want to filter further the results I get on a query which contains 2 fields "average no of transactions" and "no of transactions". I want to... colmkav	05-24-2012 06:50 AM colmkav	5	37
SQL query that uses parameters Hi, I am trying to write an Access query where I choose the tablename the results will be output to. I thought the following should work but I end... colmkav	05-24-2012 06:08 AM Bob Barrows	5	38
Access10: used for a photos database? I have Access10 that I use for invoicing etc and I want to use it for sorting and cataloging my photo collection. There are over 3000 photos... Peter Jason	05-23-2012 04:17 AM Phil	4	43
Print Excel 2010 Sheet to PDF from Access 2010 Hi, I have an Access app that I need to do the following: 1. Open an Excel file 2. Change a value 3. Print a sheet to pdf 4. Close Excel... raeldush@gmail.com	05-22-2012 07:02 PM raeldush@gmail.com	2	35
Google groups "Clif McIrvin" <clare.moe (AT) gmail (DOT) com> wrote (I got an error when posting ... this may be a duplicate posting) On Friday, March 30, 2012... Jim Devenish	05-21-2012 09:24 PM Neil	7	47
Force Instantiation Of Excel 11? I've got an environment where both Excel 11 and 12 have been installed for a year or so. Excel 11, however, was the default version. But recently... (PeteCresswell)	05-21-2012 07:39 PM (PeteCresswell)	0	38
loop through records and run a function before update a field...head strom ( 1 2 3 4 ) On Thursday, May 17, 2012 9:12:27 AM UTC-5, Clif McIrvin wrote: <snip> I posted in haste ... and left a couple errors in SetRiskLevel. Because... Maya	05-21-2012 10:51 AM Clif McIrvin	33	77
Access 2010 Data Macros: The Three-Legged Hunting Dog With One Bad Eye ( 1 2 3 ) Well, if it were a bound form, then I'd be copying from the table, right? :-) So, yes, an unbound control on a form. It's an unbound text box that... Neil	05-21-2012 08:51 AM Patrick Finucane	26	74
Indexed field In Access 2010 I defined a table field as indexed no duplicates but I have no idea how to use this index to find and display any particular record on... joan4eric@gmail.com	05-21-2012 12:38 AM Access Developer	4	47
Security and synchronization question ( 1 2 3 ) I just met with a new client who needs a couple things that, last I heard, Access 2010 doesn't support: Security and Replication... Danny J. Lesandrini	05-20-2012 10:52 PM Gene Wirchenko	28	76
Struggling with a query Members Table MemberID ' Key MemFirstName MemHeadOfHouseID eID Long. All the family who live together have the same MemHeadOfHouseID. This points... Phil	05-20-2012 11:59 AM Phil	4	47
Select Sort on one of 4 or 5 fields I have a list box and a text field on a form. The user enters a tyre (tire) size into the text field and the OnUpdate event requeries the list box... BobbyDazzler	05-18-2012 05:38 PM Phil	2	36
Access 2010 Navigation Pane Scroll Bar When I use the scroll bar in the Navigation pane, the scroll refuses to stop at the selected item, but instead moves several lines away. I've seen... Bob Darlington	05-17-2012 09:32 AM soreeyehall@gmail.com	2	49
Excel 2003 vs 2007: "Yield" function from VBA? Seems like "Yield" is more than just broken like AccrIntm was. In 2003, this works: ?gExcelApp.Evaluate("YIELD(" & mySettlementDate & "," ... (PeteCresswell)	05-16-2012 02:20 PM Patrick Finucane	1	39
High Performance High Definition Browser Database SuperBrowser Ver. 1.35 High Performance High Definition Browser. Free 30 Day Timed Version, (WebSite) link Below GUI Images. High Performance High... scott93727@gmail.com	05-15-2012 09:03 PM scott93727@gmail.com	0	31
Access 2010 32-bit runtime installation error with 64-bit office ( 1 2 3 4 5 ) Hi, How do I resolve this??!! We have a client trying to install our runtime application created with Access 2010 32-bit and she is receiving this... PW	05-15-2012 05:33 PM PW	43	105
table structure / calculated modulus question I believe this to be a normalization question: I'm thinking about building an Access process to replace a paper system. One piece of the puzzle... Clif McIrvin	05-14-2012 09:27 AM Clif McIrvin	4	32
split comma separated text field values and creat new records foreach one in the underlying table via form Dear all, it's been a while I'm searching that solution on the Net. If anyone can help, I'll sleep again. Here's what a friend of mine asked... S³awomir Majchrzak	05-12-2012 05:12 PM Maya	8	40
Access 2010 ReportacFormatPDF Hi NG When I make a PDF from a report, the pics in the report are missing in the attached PDF file... Anybody...??? code DoCmd.SendObject... Bjarne S. Nielsen	05-11-2012 04:42 PM bsn	2	45
2003 vs 2007: .Run vs .WorksheetFunction One of my apps just bit the big one when IT changed it's Citrix environment form MS Office 2003-only to 2003 + 2007. The offending code... (PeteCresswell)	05-11-2012 03:46 PM Patrick Finucane	2	27
Subform combo wont dropdown with F4 key. I have Access10, Win7 SP1, and in all previous versions of Access the subform and subsubform combos would dropdown when the F4 key was pressed. How... Peter Jason	05-11-2012 03:04 AM Phil	5	35
Changing Currency Format I have an Access 2010 application designed in Australia (on a Win 7 Pro) PC, A prospective client in UK has asked if the program could be modified to... Bob Darlington	05-07-2012 05:31 PM Bob Darlington	0	40
checking connection to network I have a split database with the back end on a server. One user has his front end on a laptop. When he is in the office he connects to the network... Keith	05-07-2012 07:26 AM The Frog	9	39
Holiday Dates ( 1 2 ) Hi, I first have a table called Holidays this has the fields HolidayID (autonumber) and HolidayDate (Date), the holiday date field has many dates... Dave	05-06-2012 04:34 PM Dave	10	62
Access vba to run an excel macro Hi All, I think my first post got sucked into a black hole so I'm posting it again..... In Access2003 I have this vba code that opens and refreshes... bobh	05-04-2012 03:20 PM bobh	2	36
Click on query output and open form Hi Access gurus, Not sure if I should ask this question on queries or forms. I would like to implement a convenient search feature. By using queries... Lane	05-04-2012 11:08 AM Phil	5	36
How do you add/remove Filters (queries?) from the Advanced FilterSort / Load from Query / Applicable Filter Menu? I see you can add to this menu by creating a query in the underlying filterwindow, and then Save as query. Next time you click the load from query,... BrianDP	05-04-2012 11:08 AM BrianDP	0	32
Can a single control in a form update 2 data items at the same time? Dear Access Gurus, I have a special situation in which a single control in a form will need to update 2 data items in a table at the same time. From... Lane	05-04-2012 02:19 AM Lane	3	39
return position of highest nbr Hii All, I've been trying to get a ParamArray working to return what position it found the highest number in and I can't seem to get it... bobh	05-03-2012 08:20 AM bobh	3	31
Excel charts disappear after update from Access I seem to have amazing disappearing Excel charts and I need to find out how to prevent them from disappearing. My process starts in Access. A VBA... septimus	05-02-2012 11:21 PM raeldush@gmail.com	4	43

Page 10 of 829

110

510

Last »

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off