A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 0.58 seconds.
Search: Posts made by: Dorian
Forum: New Users May 28th, 2010, 01:05 AM Posted to microsoft.public.access.gettingstarted
Replies: 1
Views: 533
Posted By Dorian
Error Message

If you hit CTRL-BREAK when the dialog box pops up, it may take you to where
the error is. Otherwise you will have to insert messages into your code to
trace where the error is occuring. It could be...
Forum: General Discussion May 28th, 2010, 01:05 AM Posted to microsoft.public.access
Replies: 6
Views: 637
Posted By Dorian
getting data from a text file

Your file is in the wrong format for automatically importing to Access.
You need to get your file into a format like a spreadsheet where you have
the field names going across and the value for each...
Forum: General Discussion May 27th, 2010, 10:21 PM Posted to microsoft.public.access
Replies: 3
Views: 501
Posted By Dorian
dates are not entered in a consistent format

How can you possible figure out a day and month for 1998?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"daisy" wrote:

Is it...
Forum: Database Design May 27th, 2010, 10:10 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 0
Views: 534
Posted By Dorian
Employee Training Help

It sounds like both Employee and Training are one to many with Completed
Training
However since you might want to tracj scheduled training (not yet complete)
you might want to rename the third...
Forum: Database Design May 27th, 2010, 10:04 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 3
Views: 578
Posted By Dorian
Auto Increment by 1 Letter

Its pretty easy to do. Set up a string with all letters in sequence with an
extra A at end.
Dim strAB = "A........ZA"
Then you use INSTR function (look in HELP for details) to locate the letter
and...
Forum: Database Design May 27th, 2010, 09:52 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 0
Views: 459
Posted By Dorian
Populate a new field in an existing table

Write a query to do an insert into that column for each row...

Update MyTable Set [Financial Year] = "2009-10" Where [Financial Year] IS
NULL;

By the way, I strongly advise against using any...
Forum: Using Forms May 27th, 2010, 09:28 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 550
Posted By Dorian
get data from a table not in a query

You have not explained very well. You say "I have a query" but you don't say
what the query does. You need to post the complete SQL of the query. What
table is your form bound to?
-- Dorian
"Give...
Forum: Database Design May 27th, 2010, 09:08 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 0
Views: 575
Posted By Dorian
Auto Increment by 1 Letter

Sorry, I was assuming you knew how to write Access code.
You will need to create a VB function to perform this task.
I don't have much time now as I have to go to a meeting, look for a response
in...
Forum: General Discussion May 27th, 2010, 09:08 PM Posted to microsoft.public.access
Replies: 1
Views: 603
Posted By Dorian
Hide or Disable Add New Record Button

Have your custon 'add button' set the alloweditions to true when it is
clicked and then set it to false once it has finished doing the add.
-- Dorian
"Give someone a fish and they eat for a day;...
Forum: General Discussion May 20th, 2010, 12:59 AM Posted to microsoft.public.access
Replies: 5
Views: 161
Posted By Dorian
how to pass form name to a module?

Call the function in your OnClick event.
Pass the form name as a parameter to your procedure or function.
Call DisplayFormName("formname")
-- Dorian
"Give someone a fish and they eat for a day; teach...
Forum: Running & Setting Up Queries May 19th, 2010, 10:42 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 500
Posted By Dorian
Updating text field to new numeric field & moving minus sign to fr

CLng is dropping the fractional part.
Try using CDbl ?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"RyNC" wrote:

Hi,
Forum: General Discussion May 19th, 2010, 05:05 PM Posted to microsoft.public.access
Replies: 5
Views: 209
Posted By Dorian
Access hyperlinks ignore file associations

Set the file associations in your browser.
The internet is not in the Windows world.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a...
Forum: Running & Setting Up Queries May 19th, 2010, 05:02 PM Posted to microsoft.public.access.queries
Replies: 5
Views: 825
Posted By Dorian
Concatenate Text Fields to Date Field

Try surrounding whole thing with CDate( )
e.g.
INSERT INTO ....... SELECT CDate([tblTable].[fMonth] & "/" &
[tblTable].[fDay] &
"/" & [tblTable].[fYear]) AS fDate

or maybe try...

INSERT INTO...
Forum: General Discussion May 10th, 2010, 04:37 PM Posted to microsoft.public.access
Replies: 4
Views: 98
Posted By Dorian
New Record

Try:
If Me.dirty then me.dirty = false
This should force update of the current record.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a...
Forum: General Discussion May 10th, 2010, 04:35 PM Posted to microsoft.public.access
Replies: 3
Views: 125
Posted By Dorian
CAN'T ENTER DATA TO THE DATABASE

Go into debug and find the problem code then post it here.
Maybe you are missing a reference.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a...
Forum: Database Design May 10th, 2010, 04:30 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 11
Views: 1,087
Posted By Dorian
Update - Microsoft Responds to the Evolution of Community

Where exactly are the MS Access 'forum's. I just spent 30 minutes looking for
it. Got several javascript runtime errors in the web pages - and I'm using
Internet Explorer!
-- Dorian
"Give someone a...
Forum: General Discussion May 6th, 2010, 09:37 PM Posted to microsoft.public.access
Replies: 3
Views: 129
Posted By Dorian
changing forms

You have not explained what you want very well.
Guessing what you might want....
You can store the value in a control in a global variable.
Do this in the controls AfterUpdate event.
In the Forms...
Forum: General Discussion May 6th, 2010, 04:34 PM Posted to microsoft.public.access
Replies: 4
Views: 111
Posted By Dorian
Share db by network

Contact your network or technical support people, its not an Access problem.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"e929"...
Forum: Using Forms May 6th, 2010, 04:31 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 266
Posted By Dorian
Help With SQL

By doing that you will end up with a table that is not normalized!
You should only calculate such totals when you need to display them such as
in a form or report.
-- Dorian
"Give someone a fish...
Forum: Database Design May 6th, 2010, 04:27 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 3
Views: 575
Posted By Dorian
Proper Table(s) Layout

I would read up on the rules for database normalization.
If your different types of contract have substantially different data
requirements, I'd put anything common in one table and anything...
Forum: Running & Setting Up Queries May 5th, 2010, 11:25 PM Posted to microsoft.public.access.queries
Replies: 5
Views: 199
Posted By Dorian
Need some query help.....

If you want to pull data from more than one table, you need to JOIN the two
tables based on a common field. E.g.
SELECT Project.*, TES.* FROM Project INNER JOIN TES ON Project.Badge =
TES.Bdg
--...
Forum: Running & Setting Up Queries May 5th, 2010, 11:17 PM Posted to microsoft.public.access.queries
Replies: 4
Views: 864
Posted By Dorian
Create a Query that Prompts for Date and Time

Post the full SQL text of your query.
Use BETWEEN not = and =

Here is sample:
SELECT CaseNumber, Unit, CMPFiledDate, CMPRcvdDate, CMPPlus30, CMPPlus60
FROM [MyTable]
WHERE CMPFiled = True AND...
Forum: Running & Setting Up Queries May 5th, 2010, 11:00 PM Posted to microsoft.public.access.queries
Replies: 4
Views: 864
Posted By Dorian
Create a Query that Prompts for Date and Time

You can do it in a query but it's much better to create a form for the user
to enter the dates and times and then to run the query from a command button.
The query will refer to the form controls...
Forum: Running & Setting Up Queries May 5th, 2010, 10:58 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 218
Posted By Dorian
Help with InStr in a query

Try:
mid(WorkWeek2,instr(WorkWeek2,'ww')+2)
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"cherman" wrote:

I have values like "2010...
Forum: New Users May 5th, 2010, 05:10 PM Posted to microsoft.public.access.gettingstarted
Replies: 9
Views: 687
Posted By Dorian
Access

It sounds like you might be a manager.
You have probably asked the wrong question.
There may be better ways to achieve what you want.
Why do you want to know this?
What use will be made of this...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 06:20 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 OfficeFrustration.
The comments are property of their posters.