Sponsored Links

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

Page 20 of 816

Threads in Forum : comp.databases.ms-access

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
remote search speed Hi: My apologies if you've read this before; I tried to post the question yesterday, but although Google told me it was posted, it has... jan@dontspamme.com	10-12-2010 04:49 PM jan@dontspamme.com	2	3
Application Design Advice All, Thanks to everyone on this group for your helpful posts. I wanted to ask you for some advice about a design approach before I go too far down... Ralph	10-12-2010 01:57 AM The Frog	2	3
unable to put an option group on a subform without crash I have 1 subform in an access 2003 database that any time I put a option group on it and hit save the database crashes. Any other type of control is... sparks	10-11-2010 11:09 PM SB 777	9	10
Output to file Hi, Within Access2003 I use this peace of code: Open Filename For Output As #1 Print #1, SomeText Close #1. When I read the contents of Filename,... imb	10-11-2010 01:50 PM Stuart McCall	8	9
multiple users' simultaneous access to a MS Access database ( 1 2 3 4 ) When my end user clicks on the icon for her MS Access database (the icon is on her Novell NAL menu) she is successful in opening... zufie	10-11-2010 01:43 PM David-W-Fenton	33	34
Why can't I hide a form ( 1 2 ) Snippet of code ElseIf = -32768 Then ' forms DoCmd.OpenForm ObjName, , , , acFormReadOnly, acHidden Set Frm = Forms(ObjName) Call... Phil	10-11-2010 12:33 PM David-W-Fenton	10	11
Application Design Advice All, Thanks for all your helpful posts to this group. I wanted to ask your design advice before I go too far down the wrong path... I have a... Ralph	10-11-2010 02:24 AM The Frog	2	3
contare i clienti Ciao, forse per voi sarà una cosa banale ma io non riesco. Ho due tabelle, clienti e ordini (un classico): clienti: id_cliente, cognome,... remigio	10-09-2010 10:25 AM remigio	2	3
Report's recordsource Snippet of code to get the recordset of a form or report If = 5 Then ' Query Call... Phil	10-09-2010 09:33 AM kate suomah	3	4
row height in a subform Hi I am able to change rows height of a continuous form containing 3 fields with a button containing the following code .height = 480 .height =... jean	10-08-2010 04:54 PM Salad	1	2
Rounding Up To Next .25 Increment: Alternative To IIF() ? I've got a bunch of bond rating weights from 0 to 7 in increments of .25. My input file has decimal numbers from 0 to 7, but not in increments of... (PeteCresswell)	10-08-2010 03:23 PM (PeteCresswell)	8	9
Export to Pivot Table I am attempting to create a pivot table in Excel. (Aside: I cannot get the Pivot table Form Wizard in Access to work, so am exporting to Excel and... Jim Devenish	10-08-2010 02:19 PM Jim Devenish	0	1
Creating an Excel Pivot table Apologies if this appears twice but my first posting seems to have got lost.. I am attempting to create a pivot table in Excel. (Aside: I... Jim Devenish	10-07-2010 02:33 PM Jim Devenish	0	1
jump to a record in a datasheet form Hi All, I have a form(A) and subform(B). Form B is a Datasheet form containing records. One of the fields is a unique number and consists of the... Co	10-07-2010 01:01 PM Marshall Barton	4	5
Record is deleted. ,DAO.Database ,3167 I have a BE reporting.mdb, its tables are linked into the FE Because of the constant deleting/inserting of data, there is bloat to solve this, the... Roger	10-06-2010 04:12 PM David-W-Fenton	1	2
set LinkMasterFields programmatically Hi: I have a database created in A2003 that I'm converting to A2007. It's throwing an error that's driving me crazy because the code has... jan@dontspamme.com	10-05-2010 10:56 AM jan@dontspamme.com	6	7
CreateQueryDef ( 1 2 ) Create a temporary query in a function using Set qryDef = currentdb.CreateQueryDef("", SqlString) on a Jet BE. Do I need to close qryDef or is... paii, Ron	10-03-2010 01:58 PM David-W-Fenton	10	11
Too few parameters error when setting a recordset to a query Hi, I have a query with three fields that have criteria set to fields on a form. The form is open and those fields have the proper data entered in... PW	10-01-2010 11:42 PM PW	3	4
Index on 4 fields; one is optional ( 1 2 ) First a few words on dutch names. In dutch a surname can consist of two parts: a (optional) prfix plus a surname. So "Piet van der Graaf" is a... XPS35	10-01-2010 02:11 PM bobh	11	12
trapping the x's Well 3 days ago,I downloaded a game named Fiesta Online and this thing named Xtrap was with it. Then just recently I got a virus,and I'm wondering is... varada rajan	10-01-2010 09:45 AM Eggs	2	3
Help Needed With Report Printing Problem I've installed an A2003 database at several sites and the problem I'm about to describe is only showing itself at one site. The problem also does... Wayne	09-30-2010 08:59 PM Wayne	4	5
combining PDF documents using VBA in access2007 if I have multiple PDF documents in multiple folders, is there a function in access2007 to combine them into one, new PDF document ? if not in... Roger	09-30-2010 05:56 PM Bob Quintal	1	2
My subform is out of control! I have a form frmProducts with fields such as ProdID which are based on tblProducts. I have a subform in this form SfrmSub where I enter values (all... WhathaveIdone?	09-30-2010 03:16 PM WhathaveIdone?	2	3
Access Bug We are having the same problem with the #Deleted message. What is the case number that you have with Microsoft Access? Where can I view the problem... Mike Demahy	09-30-2010 10:17 AM Mike Demahy	0	1
Archiving/restoring 'deleted' records ( 1 2 3 ) I have a database that has been in use for some years. Within this there are tables for Orders, OrderDetails, Deliveries and DeliveryDetails. The... Jim Devenish	09-29-2010 03:12 PM David W. Fenton	24	25
access2007 conditional formatting I've got a simple form with an unbound field, plannedWA, which is set to 100 a second unbound field, totalWA has a control source of =plannedWA + 1,... Roger	09-29-2010 02:45 PM Roger	2	3
Query expression not supported. 3075 syntax error Hi All, I use this query as a recordsource but it is not accepted: strSource = "SELECT Tabel_Aanvragen., VISA. " & _ "FROM Tabel_Aanvragen INNER... Co	09-29-2010 01:33 PM John Spencer	4	5
Slowness of DLookup ( 1 2 3 ) In another postibg I was querying the speed of DLookup, and was told that the performance was good. I have a simpllifies Table - Member, with about... Phil	09-28-2010 03:35 PM Phil	21	22
A2010 And Sharepoint Cals I'm still trying to wrap my head around the A2010, Web publishing apps, and Sharepoint CALS. If I upload the datafiles to a Sharepoint site as the... Salad	09-28-2010 03:16 PM David W. Fenton	7	8
unable to open record in subform while running filter Hi All, I use a form with a subform. When I set a filter to show only records from a certain date I change the source to this: strSource = "SELECT... Co	09-28-2010 12:02 PM Co	2	3
Quotations marks in an INSERT INTO statement string ( 1 2 ) Hi, I'm using A2003 on Windows XP SP3 I am using an INSERT INTO statement to add entries to a temporary table. There are three values; Activity... franc sutherland	09-28-2010 08:30 AM paii, Ron	10	11
Keeping Form invisble until all data loaded ( 1 2 ) Apart from waiting an arbitrary period before making a Form visible is there no way in Access to know when all data has been calculated so that the... Jon Lewis	09-27-2010 12:45 PM David W. Fenton	15	16
Print preview won't print I have a button on quite a complex form (with 3 combo boxes, 1 listbox and 3 continuous subforms, 1 with 2 combo boxes) This has a button which... Phil	09-27-2010 11:56 AM Phil	0	1
Create Multiple Records I need some assistance and insight into creating multiple records in Access from a single record in another table. For instance, I have a form with... Bolen	09-27-2010 09:54 AM Marshall Barton	1	2
Citrix Question Regarding Data Corruption ( 1 2 ) I have an Access FE/BE database running on Citrix. Until recently all was well with no problems during 12 months of daily use. Recently the data... Wayne	09-26-2010 02:40 PM David W. Fenton	14	15
Developing A Graph From A Query I have created a form so that sections A - D can enter progress such that a weekly tally can be made to create a glide path of work remaining to the... bezz	09-26-2010 02:31 PM bezz	0	1
text box limit Hi, sorry for my english using Access 2003, in a form there's a cmbbox that saves values in a text box. I've made it using the wizard. I. e.... remigio	09-26-2010 11:42 AM remigio	2	3
Data on a password-protected website I have a client who wants to be able to export data from their Access database to a password protected website for their employees to be able to view... Neil	09-24-2010 06:18 PM Stuart McCall	1	2
access2007/sql2005 query problem I've got a sql table that is linked into access2007 (latest service packs, etc) tblHoliday holidayId pk branch text holidayDate... Roger	09-24-2010 02:12 PM David W. Fenton	2	3
Field display as ###### in A2010 In A97 if the data for a numeric or date field was wider the space provided on the form or report, it displayed the data that fit. In A2010 it... paii, Ron	09-22-2010 04:03 PM Tony Toews	5	6
Whitepaper - Measuring data quality for successful MDM Yellowfin Business Intelligence have released a whitepaper on measuring data quality for successfull master data management. Download Link (No Email... JTP PR	09-22-2010 09:02 AM JTP PR	0	1
Trapping the X? ( 1 2 ) In a form I might have a BeforeUpdate event that does some final validation before saving a record. Ex: If IsNull(Me.LastName) then msgbox "Please... Salad	09-21-2010 03:44 PM James A. Fortune	16	17
Access login/privileges Hello, I want to setup logins (user & password) for an Access DB and assign different levels privileges to those users. Is this possible in Access?... Joe Smith	09-20-2010 04:34 PM David W. Fenton	6	7
formatting currency my regional options has the currency symbol as a comma (French format) but I'd expect this ?format(1.2,"#.00") to display 1.20, yet it displays... Roger	09-20-2010 01:24 PM Salad	1	2
Multiple Reports From Recordset Hi, I want to use a subroutine to print a subset of records from a table. I tried an option box using select case, as there is a field called... bezz	09-20-2010 09:19 AM John Spencer	1	2
VBA create multiple fiield indexes The code below creates a unique index called MemAddID With MyTblDef Set MyField = .CreateField(FieldName, dbLong) MyField.Required =... Phil	09-20-2010 03:19 AM Phil	2	3
Control Panel The following code opens the control panel Public Function ShowControlPanel() As Boolean On Error Resume Next Shell "rundll32... Salad	09-18-2010 11:50 AM Salad	4	5
Access 2007 tabular layout - checkbox alignment When selecting a bunch of controls and then selecting tabular layout each checkbox control is aligned left. I would like the check boxes to be... Paul H	09-18-2010 02:48 AM Reginald Merritt	1	65
how do you change a date format like this one I got some data that has the dates as 10/24/02 But its yyyy/dd/mm so its FEB 24, 2010 but access sees this as 10/24/2002 I tried format(, "dddd... sparks	09-17-2010 04:29 PM Salad	2	3
Printing Multiple Reports From a Recordset Hi, I want to use a subroutine to print a subset of records from a table. I tried an option box using select case, as there is a field called... bezz	09-17-2010 10:56 AM bezz	7	8

Page 20 of 816

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