Rating Thread / Thread Starter	Last Post	Replies	Views
Button Effects on Access forms Hi There, I have a form with a number of buttons on. Instead of using a standard button for the exit command (which would be grey - or whatever... John Ortt	06-14-2005 10:32 AM John Ortt	5	56
Database Permission Settings Hello all, I'm a newbie with Access and had a (hopefully) simple question. I have a database that is basically one table and I want to load it up... Aaron Deskins	06-14-2005 09:08 AM Aaron Deskins	0	49
Re: To All "PC Datasheet" <nospam (AT) nospam (DOT) spam> wrote <snip drivel> What is your question about MS Access? FFS, nobody CARES if someone is coming... Keith	06-14-2005 08:48 AM Keith	1	139
Syntaxerror in Designview -> How to correct wrong SQL-Syntax? Hi, Situation is: Used an embedded query which was "optimized" be Access with Brackets ("()" -> "."). Now problem is: I get the error "Syntaxerror... Adfra	06-14-2005 06:25 AM Adfra	5	45
dynamically control form objects If you have say 20 option buttons named option1, option2,...,option20 and their corresponding labels label1, label2,....,label20 is there any way you... missimaths@hotmail.com	06-14-2005 05:21 AM Hank	1	48
# of Months Calcuation only returns 0 I'm trying to create a function that calculates the number of months between two dates. DateDiff won't work because I need to add one month if the... lpeterson@aipt.org	06-14-2005 03:50 AM Mike Preston	3	36
Running Balance Help wanted Hi Guys Can anyone help I am trying to find a way to implement a running balance that will re-calculate if the date order is changed, or if an... bobdydd	06-14-2005 03:34 AM bobdydd	4	47
date comparison Hey all, I've got to show records from a table that are 45 days old or newer.. im not quite sure how to do this in SQL ... Select field from table... Beacher	06-14-2005 02:35 AM Chandra	3	51
how can i 'select' items in a list box from a button click Hello all, I have a listbox with 2 'fields' and a choice of 100 or so items that can be selected. User can select multiple items (i'm using the... Andy Warner	06-14-2005 02:15 AM Andy Warner	2	54
Is there a way to automate importation of Excel data? I have around 400 excel files filled with data that I need to import in ACCESS. The tricky part is that they must be imported one at time, and... John Marble	06-14-2005 01:29 AM jr	3	42
Problem grouping records by certain time frame (report) Hi, I recently encountered a problem while trying to create a report grouped by certain time frames. However, Access only allows grouping in Minutes... CH	06-14-2005 12:31 AM Allen Browne	4	46
To brows to a folder or file Dear reader, For browsing to a file in a folder I am familiar with two windows, one with the following options on the left side of the window: · ... S. van Beek	06-13-2005 11:02 PM Salad	1	46
Specifying parent child form by name I have form with subform that has a button(one in parent, one in the child) that calls the microsoft access find/replace object. In order to make it... tdmailbox@yahoo.com	06-13-2005 10:09 PM tdmailbox@yahoo.com	4	46
object variable or with block variable not set I have the following code which produces an error. Basically, I have two queries which I am using to enter new records into two tables, master and... ronvhill@alltel.net	06-13-2005 07:33 PM rkc	1	47
Extracting data from Excel into Access Table Here is an issue i've been trying to figure out which i do not have an answer to. Basically i have an excel spreadsheet which has data that i copy... phong.lee@gmail.com	06-13-2005 06:55 PM (PeteCresswell)	5	57
CopyFromRecordset does not work on different machine I have an Access Application which happily uses CopyFromRecordset to transfer values from an access query via a recordset to an excel spreadsheet,... info@lowerbill.co.uk	06-13-2005 06:48 PM MacDermott	1	69
object variable or with block variable not set I am encountering an error on the following code. Basically, I have two queries which I am using to enter new records into two other tables, one a... ronvhill@alltel.net	06-13-2005 02:42 PM David W. Fenton	1	45
Colour Cycle in forms? Hi there, I have written the following code to colour cycle the background in one of my forms. The problem is it only cycles from Black to Red and... John Ortt	06-13-2005 02:19 PM Kevin Nechodom	8	54
Report objects Hi, I have an image and an text label on my report. What I need is...If the txtCountry is not 'United Kingdom' then lblAirmail is VISABLE... N J	06-13-2005 01:12 PM N J	2	59
Field to Field data duplication I am creating a new database, that will contain 2 fields that will have the same data. The DB is an inventory of computers. the fields I want... Bryan Warren via AccessMonster.com	06-13-2005 12:59 PM Larry Linson	3	53
Question 2: automatically update an embedded XLS-flie Hi, I am having two problems with Access 97. These 2 problems are posted seperately in this newsgroup. Here's the second (and probably... jan Veenstra	06-13-2005 12:42 PM jan Veenstra	0	43
Closeing MSQuery Window from Access Hello, I am trying to close the MsQuery window from within an Access 2000 module. On Dev Ashish's site, he has code to find the class name and... BerkshireGuy	06-13-2005 12:36 PM BerkshireGuy	0	44
Numeric column in Excel Hi, Please check the code snippet below. I want the 4th column be numeric. But, in the result it is always showing as text. Any suggestions to... KK	06-13-2005 12:25 PM KK	0	38
MS ACCCESS has encauntered a problem and needs to close ... I have written a pretty complex ACCESS accounting aplication which is working fine.But under some circumstances I get this nasty error... ljubo lecic via AccessMonster.com	06-13-2005 12:11 PM Tony Toews	3	42
Disable Shift Key. Help! Hi i'm trying to disable the shift key from allowing users to access the design view. I've done a search in groups and know i need to somehow do... simonmarkjones@gmail.com	06-13-2005 10:26 AM Tanis	1	59
Checking the value of a field in a table from Code Hi. I know there is a simple answer to this one but for the life of me I can't get it. I have a login form where users type their username and... ColinWard	06-13-2005 08:45 AM ColinWard	2	47
RE: Page Breaks We have a Laserjet 2100 Printer that prints a report in Landscape layout but inserts 'page breaks' into the middle of the record and then continues... R Graham	06-13-2005 08:40 AM R Graham	0	55
Problem with control source for text box on report I want to use an expression as the control source for a text box in a report (Access 2000). Whilst I have sucessfully used these simple... VivN	06-13-2005 08:37 AM VivN	4	50
Find the length of text stored in a textbox? Hi all! How can i find out the length of text stored in a textbox on a form? I have one textbox which updates a second textbox. But max... simonmarkjones@gmail.com	06-13-2005 08:29 AM John Ortt	2	49
Setting form properties in VBA: do I need numbers? Hi, I'd like to set form properties in VBA. You can set e.g. Forms("frmDemo").BorderStyle = 3 but how can you set Forms("frmDemo").BorderStyle =... alsemgeest@it4us.nl	06-13-2005 07:57 AM Mike MacSween	1	102
Access application dies connected to Oracle databases If anyone has seen this before, please help. I work at a company that has an Access application front end attached to tables in an Oracle... s-dogg	06-13-2005 07:55 AM Tim Marshall	1	44
4k Table limit Hi, I was wondering how the 4k table record limit is counted. I have access 2k. I text fields are 256 chars. Memo fields are not included in... ken	06-13-2005 07:38 AM Ed Robichaud	3	64
How to create table? A simple question. I would like to know the equivalent instruction in ACCESS (or SQLSERVER) for the following (works with oracle) create table... tommaso.gastaldi@uniroma1.it	06-13-2005 06:54 AM tommaso.gastaldi@uniroma1.it	2	51
Do I need to set form properties every time?? Hi, I'd like to change the properties of the default form design. Every form I need to change many settings. Especially the following properties (I... alsemgeest@it4us.nl	06-13-2005 05:17 AM Wayne Morgan	7	63
Prevent textfield from being deleted from but allow updates Hi i need to prevent a textfield on a form from being deleted from but allow updates/ append to any text already stored in the database. How can i... simonmarkjones@gmail.com	06-13-2005 03:00 AM simonmarkjones@gmail.com	4	51
Lock Cells Hi, Is there a way to lock certain cells in a MS access table from editing? Thanks ken	06-13-2005 02:19 AM Keith	3	86
Changing Unbound Field Name Hi I seem to be getting nowhere with this. I am opening a form which will be used to input Notes into different fields in a table. My problem... David	06-13-2005 12:30 AM David	5	50
Unable to open database Hi, A problem I ahve not encountered before. We use a database to write students reports and it has been pretty stable. A user received the... John M	06-12-2005 10:41 PM John M	3	69
insert statement on sale report I want to make a check if customer doesnot pay full amount then his dues go in to his account recieveable table. I am trying this in... khan	06-12-2005 04:59 PM Ed Robichaud	9	46
DateTime problem Hi folks I have an C# app. connecting to a MS-ACCESS database with several tables. In a specific situations I have problems with a DateTime type in... Kim Würtz	06-12-2005 01:45 PM Kim Würtz	4	50
How to specify Range when exporting to Excel with JET? I use a complied query to export to Excel like this: SELECT * INTO . FROM tblExcelData; But I have a situation where I need to export several... deko	06-12-2005 01:09 PM deko	2	57
Advice on Looking up Hi all, Sorry for the long post, but I don't know how else to explain this one. Just after some advice really as I'm finding it difficult to update... bradsalmon	06-12-2005 07:38 AM Chuck Grimsby	3	59
Switch function max number of varexpressions in Access xp I have a niggle with the Switch function I have a querey which has a column with 3 digit values of which there are about 20 which are... jr	06-12-2005 07:15 AM jr	2	58
SQL synthax problem on INSERT INTO instruction. I am quite new with Access, so please be indulgent if my question sound a little bit newbish. I have two table in the same database: DOSSIER and... John Marble	06-12-2005 06:56 AM jr	3	61
File convertion I recently converted some Access 97 database into Access 2003 and encountered some errors. After I converted the databases, there is a Conversion... Ray	06-12-2005 04:49 AM Br@dley	1	63
Find file window Dear reader, For browsing to a file in a folder I am familiar with two windows, one with the following options on the left side of the... S. van Beek	06-12-2005 03:37 AM S. van Beek	0	50
Twips and Pixels: Please confirm I've been working with the Twips/Pixel issue and after reviewing the Acc.Dev.Hnd book and the groups, the standard seems to be ... 640x480 15... cefrancke@yahoo.com	06-12-2005 12:32 AM Steve Jorgensen	1	66
How do I change an MS Access Database PAssword from VB Code I am trying to change an existing database password from VB 6. The database is an MS Access 2000 database if this helps How do I do this? Any... alijsyed	06-11-2005 10:06 PM John Mishefske	3	69
update Access table by VBA in Excel How can I update an Access table based on a sheet in Excel by VBA in excel. Thanks john_liu	06-11-2005 09:57 PM Larry Linson	1	53
Too many Forms Open I am a complete newbie with no code experience. I have a form that acts as a switchboard. When I click on a button to open a new form, the old form... rbp1976@gmail.com	06-11-2005 08:01 PM rbp1976	5	67

Page 420 of 820

420

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