Rating Thread / Thread Starter	Last Post	Replies	Views
how to check date ? Hi there, how are you? I have question, assume I have a text box and gave it a format date&time, how can I check when it is empty or not empty I use... Tu Quach	01-05-2004 06:45 PM xzzy	2	70
insert into select i received a runtime error message 3346 when i ran the insert into select code. i have check to see if the query values and destination fields are... JMCN	01-05-2004 05:22 PM JMCN	4	65
Conflict viewer says there are conflicts, but shows no tables Hi, I apologize for posting this a second time, but no one replied from the other group where I posted it. I have a design master and 4 replicas... VHR	01-05-2004 03:37 PM VHR	0	65
query problem hello. ive been fighting this problem for 3 days now, but still didnt solve it. heres what ive got: 1 table contains... stoker	01-05-2004 03:32 PM stoker	3	82
How terminate objects cleanly when access close ? Hello, I'm working on an access application, at the opening of the application I create some objects (in order to do this I use the AutoExec... Thomas HAMEL	01-05-2004 02:23 PM Steve Jorgensen	2	62
Label Position for a 3-D Chart. By default when you enable the data label in a 3-D Bar Chart, the data label starts in the middle of the bar chart. There is no Label Position option... Jacky11	01-05-2004 01:28 PM Jacky11	0	62
Run time error 3061 I have an error with the following code Dim rs As DAO.Recordset Set dbs = CurrentDb strSQL = "SELECT * FROM table1 WHERE table1.Schedule_Item... Tu Quach	01-05-2004 01:06 PM sld.info	3	57
Re: Continuos form format Ian, I'd put a call to your function in either the On Current event or the Before Update event. I made up the following function, for a form with a... YFS DBA	01-05-2004 01:06 PM Roberto Spier	1	69
Old ms-access file, showing wrong text in access xp Dear sirs: I've one old .mdb file ( since 97). now when I open it, it converts most of text to strange unicode characters. can I stop this... Abdolhosein Vakilzadeh Ebrahimi	01-05-2004 12:29 PM Abdolhosein Vakilzadeh Ebrahimi	0	55
Removing Duplicate Data Problem..! Any ideas what to do for the best? I have a table that records some transaction data. Each entry in the table has an auto gen primary key /... En	01-05-2004 11:48 AM En	2	53
Secure Database Object Gentlepeople OS:NT 4 Office: XP Problem: Trying to get a secure database object(respects mdw file) from another Access database. Following code get... Farooq	01-05-2004 10:17 AM Farooq	1	43
Sql Query Question Help needed for project-Access 2002(office xp) PROBLEM: Figuring out how to lookup a record and DDate field in Table1 - Take that DDate-field data... JC Mugs	01-05-2004 09:44 AM Jerry Boone	3	67
Before MS makes programs try to think for us, ... they should make sure they think well enought shouldn't they make them think well enough to do more harm than good? Examples: I have a table with 4... Steve Jorgensen	01-05-2004 09:17 AM Jerry Boone	3	55
Help with DCount function and filter I posted this problem previously and received excellent help from Wayne Morgan. However, I still have an unanswered question. My... jdph40@yahoo.com	01-05-2004 08:41 AM jdph40@yahoo.com	7	48
Import text file Hi all! With the transferText method I have made a routine that import a textfile to a table.The textfile is a pricelist from the supplier. The... Sigurd Bruteig	01-05-2004 08:15 AM Sigurd Bruteig	2	67
Use the File Open Browse box I want to programatically open the Access "File" "Open" browse box to search for a file. When it is selected I wnat to have it put the path in a... Dave N	01-05-2004 07:58 AM Allen Browne	4	44
Advance Browse for Folders Dialog Hi Ok, i have loaded the appropriate code to call the Browse Save As dialog box I click a Btn from my Access form then the Dialog box appears i... DD	01-05-2004 07:21 AM David Neagle	3	51
How to use expression in conditional formatting? I have a subform datasheet in which I want to bold the text of a field if another field in the datasheet meets certain criteria. I think I want... deko	01-05-2004 07:18 AM Arno R	1	67
How to obtain field describtion with code Hi there, I am trying to write a little procedure to list all field names an descriptions for a table. However I can't find the property which... Uwe Range	01-05-2004 06:59 AM Fletcher Arnold	2	55
How to make all negative values positive? ( 1 2 ) Is there an easy way to make all negative values positive in a particular table? I've been experimenting with this: Dim rst As DAO.Recordset Set... deko	01-05-2004 05:04 AM Kinetic - Paul G	12	72
Placing jpgs (photos) in my A2K database Can someone please help me with this? I am trying to put my jpg photos in my database. Access books seem to avoid the issue of graphics in DB tables... Jeremy Simpson	01-05-2004 04:56 AM Kinetic - Paul G	7	72
Can't Open VB Editor and VB scrip won't run AFTER reopening database I created a database, thought all was fine until I quit it and opened it again. The VB wouldn't run, I couldn't open the editor from design view of... I'm a Trampoline	01-05-2004 12:17 AM I'm a Trampoline	0	69
Help needed in access to Crystal reports.. Hai I have a designed Crystal report .rpt file which has 4 access tables .. After designing the report i put a parameter field which filteres the... Raghuraman	01-04-2004 09:59 PM Raghu Raman	3	66
Replication of access db An app I wrote for courier services enables clients to login to a web page and view the current status of their deliveries. This is done with an... John	01-04-2004 09:46 PM xzzy	1	52
Can't find syntax error in Access query - lost! select event_date, event_name, event_text, event_is_public, event_is_reserved, event_img_path, event_img_alt, event_member_id, event_is_email_notify... Phil Powell	01-04-2004 08:44 PM Phil Powell	6	69
Changing one field in an updateable query to a new value on a form--without querying HI: I have a situation where I wish to enter a value in an unbound field on a form and then change the same field in each record on the form so that... John Baker	01-04-2004 07:45 PM John Baker	6	53
Best way to model hybrid single/multiple logical database ( 1 2 ) I've run across this issue several times of late, and I've never come up with a satisfactory answer to the best way to handle this schema issue. You... Steve Jorgensen	01-04-2004 07:11 PM rkc	19	92
Flaws in Access (resource) ( 1 2 3 ) To help you avoid some of the more common and long-standing bugs in Access, the page: http://allenbrowne.com/tips.html contains a new section... Allen Browne	01-04-2004 06:51 PM Allen Browne	20	103
NOT IN(SELECT ( 1 2 ) This one droves me completely mad. I did not succeed to exploit the track given to me by Bob. I have : three tables : Clubs, Persons and... Jos?	01-04-2004 05:58 PM Bob Quintal	14	159
Auto number after a look up I want to set a auto number but the first 3 digits should be picked from a value of another table like for example a customer no is 999 i want the... Vikaspell	01-04-2004 04:55 PM Roger	2	68
Replication of acess db Hi We have an access database running on a win2k server over the internal LAN. The server is protected by MS ISA Server from outside world. Is there... John	01-04-2004 04:22 PM John	0	73
Yearless birthdates Folks, I am trying to create a database for tracking birthdays. Don't have the birth year for the vast majority of these, just the month and... Harry McGuffin	01-04-2004 03:49 PM Harry McGuffin	3	59
Don't display the: "The OpenReport action was canceled" message box. Hi, For my 'On No Data' event I have the following code: Private Sub Report_NoData(Cancel As Integer) On Error Resume Next MsgBox "There is no data... LittleCheeseburger	01-04-2004 03:42 PM Salad	1	122
New record gives error in "linked" form Hi, Hope you can help me on this... I got 1 form with a sub form. On this subform there are only parts of records, so you can select the one you... Xiphias	01-04-2004 02:55 PM Xiphias	4	66
Memo Fields via a webpage/upload images? Hello all, I just found this group after doing a search on google for help with a 2 problems I am having with a database I am trying to desing to... donald	01-04-2004 02:46 PM donald	0	58
Can you install the Jet Engine in c:\windows\system in WinXP I have some old CBT software written in a package called IconAuthor. It uses Access database to store details of lessons, graphics filenames, sounds... martin smith	01-04-2004 01:16 PM Michael \(michka\) Kaplan [MS]	1	64
Custom Collection Is there any way to display elements in a custom collection in a form? Can elements me added and deleted through a form? Thanks! Mark Mark	01-04-2004 08:45 AM Tom van Stiphout	4	74
Deleting via a query with a join in it? Seems to me like I've done this. When it wasn't possible to delete the records in question via a fairly complicated query I resorted to creating a... (Pete Cresswell)	01-04-2004 07:59 AM (Pete Cresswell)	5	74
Ordering dates in sub form In a reservations app I have a sub form (in datasheet view) that displays dates in desc order. As these dates are both in the past and present I... David B	01-04-2004 06:47 AM Peter Doering	1	67
Please help: Query uses _old_ value, but I am using _AfterUpdate_ Hi all, I created a function that updates a certain status field. The status can be influenced by four different other fields. So, on the form where... Koen	01-04-2004 04:20 AM Salad	5	65
Access on web page Thanks to both for the info ... ASP.net is next on my list of "stuff to learn" -- Scott McDaniel CS Computer Software Visual Basic - Access - Sql... Mark	01-04-2004 01:05 AM Peter Chong	8	106
Wierd error on starting proven A2K App. I have a user who is unable to start an A2K app. This app runs fine everywhere else. The error he get is: "Required DLL: wwint32v.dll not found" I... WillWeGetOurFreedomBack	01-03-2004 10:36 PM Wayne Morgan	2	71
Form suddenly won't open, why? I am working in Windows 2000 and Access 2000 and am a rookie in Access. Coding merrily along, I stop periodically to test that everything... Corepaul	01-03-2004 10:21 PM Corepaul	4	69
the dirty form! I have a subform which takes one of its fields from the main form, namely the YearLevel which is from 1 to 8. There is also another field which... Ray	01-03-2004 08:52 PM MGFoster	1	105
User Input Validation - Data Checking I am using a routine to check to see if a phone number (PK) has alread been entered, and takes the user to that record if it is found --... R Bolling	01-03-2004 08:36 PM MGFoster	2	60
Newbie: Show message box when Form filter fails? I've created a Form which I use as a Switchboard and have decided to include a facility which will open an individual Form, based on a surname typed... Terry	01-03-2004 05:47 PM Terry	2	57
RecordExit Event Hi, I read in the accessXP help that there is a form event called RecordExit that may be used for data validation purposes. I tried to look for this... Osiris Sawiris	01-03-2004 05:46 PM Karl Donaubauer	2	93
How to "unlock" table in error handler routine? Is there a way to unlock a table so a subroutine can complete? frmMain!frm0 has got a lock on a table I need to do stuff with. Error Number 3211:... deko	01-03-2004 04:57 PM xzzy	1	84
Please help I need to make a project for school that intergrates Frontpage, access, word and powerpoint. I wanted to make something that would be usefull for... Glen	01-03-2004 04:44 PM Glen	0	64
Error in Pace Calculation Hi, Hoping someone can help. I've designed a running database Access 2003 but am having trouble with the pace calculation. I've googled and... SharkSYA	01-03-2004 04:44 PM Bob Quintal	6	72

Page 692 of 820

692

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