Access Form table - Database Discussion Boards

Re: Importing database from one db to other db

Mohammed Hameed16-Sep-08 23:57

16-Sep-08 23:57

Hi, you have 2 choose option "copy objects and data between sql server databases" in export wizard. Then click Next, check all the options provided, then click Next, then Finish.

If this solution solves your problem, please rate this.

Be a good professional who shares programming secrets with others.

how to create database setup?

sathyan_829416-Sep-08 6:20

sathyan_8294

16-Sep-08 6:20

i want to install the sql 2000 database in other machine.
so how to create sql 2000 database setup?

Bad question

David Mujica16-Sep-08 7:35

David Mujica

16-Sep-08 7:35

No one is going to answer your question because you have not even tried to answer it for yourself. Use Google or go to MSDN for general informaiton.

Read this before posting again: http://www.codeproject.com/KB/scrapbook/etiquette.aspx[^]

Re: how to create database setup?

Paul Conrad16-Sep-08 8:37

Paul Conrad

16-Sep-08 8:37

Jeez, I take it you never heard of Google?

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

Re: how to create database setup?

Jerry Hammond16-Sep-08 9:34

Jerry Hammond

16-Sep-08 9:34

Well, first you must build a difference machine...

“If we are all in agreement on the decision - then I propose we postpone further discussion of this matter until our next meeting to give ourselves time to develop disagreement and perhaps gain some understanding of what the decision is all about.”-Alfred P. Sloan

how can i know the size of the database

Satish - Developer16-Sep-08 3:14

Satish - Developer

16-Sep-08 3:14

Hi friends, i need to know how much space occupied by database with my data in sqlserver 2005.
to know this i did by right clicking on database and has seen it properties it showing nearly 2.4GB. But my database doesn;t contain that much data?
how can i know the exact size of my database?

G. Satish

Re: how can i know the size of the database

Blue_Boy16-Sep-08 3:35

Blue_Boy

16-Sep-08 3:35

sp_databases

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Access Form table

TheEagle16-Sep-08 0:19

TheEagle

16-Sep-08 0:19

Hi
I have an access file which contains forms,tables,queries,..

How could I know what table or query the forms are taking data from?

I am too late but i will never give up

record Source

David Mujica16-Sep-08 2:50

David Mujica

16-Sep-08 2:50

In MS-Access,
1) Open a form
2) Switch into design view
3) In the upper left corner of the form you will find a small black square. Place your mouse on the square, right click and choose "Properties"
4) On the pop-up window, click on the "Data" tab and look at the "Record Source", this is where the form is getting its data. The data can be from a table, query or a query defined only for the current form.

Hope this helps.
David

Help!!

WebMaster15-Sep-08 23:00

WebMaster

15-Sep-08 23:00

hi there!!!!
i just wanna ask for suggestions.......for my project!!!
i haven't start it yet! i don't have any idea,"what topic that i can choose" please....help me!!!!!!!!!
i have knowledge about C/C++,Vb.6 and mySQL

Re: Help!!

Blue_Boy15-Sep-08 23:08

Blue_Boy

15-Sep-08 23:08

What stops you to start your project?

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: Help!!

Ashfield15-Sep-08 23:29

Ashfield

15-Sep-08 23:29

Well, my latest project is to install a new bathroom if that helps.

Bob
Ashfield Consultants Ltd

Please read this article before posting again

David Mujica16-Sep-08 2:55

David Mujica

16-Sep-08 2:55

http://www.codeproject.com/KB/scrapbook/etiquette.aspx[^]

Re: Help!!

nelsonpaixao16-Sep-08 14:34

nelsonpaixao

16-Sep-08 14:34

do a rent-a-movie software (did one before) or library software for exemple.
They are easy & good because you can built it has a stand-alone (no need to build network if you wish) Blush | :O

Better you see samples from projects that came in ebooks.
Go to www.ebooks-space.com[^] download a ebook that cames with a project you like. Sigh | :sigh:

nelsonpaixao@yahoo.com.br

trying to help & get help

Multiple select in 1 query

Agweet15-Sep-08 21:48

Agweet

15-Sep-08 21:48

Hi...can any1 assist me plz....im using sql 2005...i have multiple selects seperated by if statements like this:

IF @Monday = 0
	SELECT [Day],[Date] FROM dbo.fnGetDatesforAday('2008/09/10', '2008/09/30','Monday')

IF @Tuesday = 1
	SELECT [Day],[Date] FROM dbo.fnGetDatesforAday('2008/09/10', '2008/09/30','Tuesday')

is there a way to execute both selects as 1 query

living life on the flip side

Re: Multiple select in 1 query

N a v a n e e t h15-Sep-08 21:55

N a v a n e e t h

15-Sep-08 21:55

SELECT 
    [Day],[Date] 
FROM 
    dbo.fnGetDatesforAday('2008/09/10', '2008/09/30',(
SELECT
	CASE @Monday
		WHEN 0 THEN 'Monday'
		WHEN 1 THEN 'Tuesday'
		ELSE 'Other'
	END

)
)

It's a wild guess, I haven't executed it though.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Removing spaces using query

M Riaz Bashir15-Sep-08 19:24

M Riaz Bashir

15-Sep-08 19:24

Hi,

kinldy let me know that, how to remove spaces using query?

Example
--------

FullName
------------------
RIAZ - BASHIR ===>>> RIAZ-BASHIR
KASHIF - HAROON ===>>> KASHIF-HAROON

Thank you in advance
(Riaz)

Re: Removing spaces using query

Ashfield15-Sep-08 20:12

Ashfield

15-Sep-08 20:12

Try this

Select replace(fullname,' ','')

Bob
Ashfield Consultants Ltd

help! Spliting Time spent on business hours and after hours

CandyHe15-Sep-08 12:11

CandyHe

15-Sep-08 12:11

Hi,

I have a programming problem to split the total time spent on jobs into business hour and after hours

business hour 8:30 - 17:00
after hour 17:01 - 8:29

database is on sql server 2005, there are job_start_datetime and job_end_datetime columns hold the jobs start and end time, also a total_time_spent column hold the total of time spent on the job.

I have an order to split the time spent into business hour and after hours. I am creating 2 filed in the table to sperate these hours. but I am having problem to using Datediff to calculate amount of hour into 2 time frames.

Can someone give me any advise how can I do that?

Thanks

Candy

Re: help! Spliting Time spent on business hours and after hours

Blue_Boy15-Sep-08 12:38

Blue_Boy

15-Sep-08 12:38

Here is idea how to implement in your real data:

select convert(varchar(15), cast(getdate()+ ' 17:00' as datetime) - cast(getdate()+' 08:00' as datetime),108)<br />
select convert(varchar(15),cast(getdate()+' 17:01' as datetime) - cast(getdate()+1+'08:29' as datetime),108)

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: help! Spliting Time spent on business hours and after hours [modified]

CandyHe15-Sep-08 13:26

CandyHe

15-Sep-08 13:26

Hi,

Thank you for your response.

I think I didn't explan it very well.

shall i explan the problem more in detail? for example, the job_time table contains following data

Job_id, Start_Datetime, End_Datetime, [Time_spent__hrs_]
1, 2001-08-20 00:00:00.000, 2001-08-21 00:00:00.000, 24.000000
2, 2001-08-21 00:00:00.000, 2001-08-21 12:00:00.000, 12.000000
3, 2001-08-20 08:00:00.000, 2001-08-21 10:00:00.000, 26.000000
4, 2001-08-13 13:00:00.000, 2001-08-17 15:00:00.000, 98.000000
5, 2001-07-18 12:00:00.000, 2001-07-18 17:00:00.000, 5.000000
6, 2001-08-24 08:30:00.000, 2001-08-24 17:30:00.000, 9.000000

I want to split the time spent hours into 2 fames, how many hours spent with in 8:30 - 17:00 & 17:01 - 8:29

Thank you

modified on Monday, September 15, 2008 7:34 PM

Re: help! Spliting Time spent on business hours and after hours

Blue_Boy15-Sep-08 16:37

Blue_Boy

15-Sep-08 16:37

select *,<br />
datediff(hh,cast(start_datetime as datetime),cast(end_datetime as datetime)) as [Time_spent__hrs_]<br />
 from MyTable

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

A different approach to storing time

David Mujica16-Sep-08 5:36

David Mujica

16-Sep-08 5:36

You may want to consider storing your data differently so that it is easier and more flexible to manipulate.

For example, consider the following:

Start_Time End_Time Type Pay_Code
06:00 8:00 WORK OT1
8:00 10:00 WORK REG
10:00 10:05 BREAK UNPAID
10:05 12:00 WORK REG
12:00 13:00 BREAK UNPAID
13:00 17:00 WORK REG
17:00 19:00 WORK OT1

Start_Time End_Time Type Pay_Code
08:00 16:00 HOLIDAY REG

This type of structure allows you to identify parts of a day and classify them appropriately. You can say that time worked before the scheduled work day is paid at overtime. You could identify a break in the middle of the day as unpaid. (Same is true for lunch) You could also then show the time after the normal work day to be at overtime. This example assumes that you are using a pay schedule where time over 8 hours in a day is paid at overtime. In the USA, most overtime is paid only after 40 hours of work.

The second example shows how you represent Holiday pay. This schema also allows for sick time (paid or unpaid).

I'll leave it up to the class to show how you can expand this data structure to include charge codes where you could identify which cost centers the labor should be applied to. Wink | ;)

Re: A different approach to storing time

David Mujica16-Sep-08 5:55

David Mujica

16-Sep-08 5:55

I tried re-posting the example data with HTML table formatting.
(You may need to scroll down to see it ... I'm not sure why there is so much white space)

Start_Time	End_Time	Type	Pay_Code
06:00	08:00	WORK	OT1
08:00	10:00	WORK	REG
10:00	10:15	BREAK	UNPAID
10:15	12:00	WORK	REG
12:00	13:00	BREAK	UNPAID
13:00	17:00	WORK	REG
17:00	19:00	WORK	OT1

Start_Time	End_Time	Type	Pay_Code
08:00	17:00	HOLIDAY	REG

Checking if a field exists in a table before adding it to another table

Twyce15-Sep-08 10:38

Twyce

15-Sep-08 10:38

Hi Guys
If anyone can help me with this it would be greatly appreciated.
K here is what's happening.I am supposed to check if a student exists in the STUDENT table and then check if a module exists in the MODULE table.if they exist in both tables I must add the student(StudentNumber) and the module(ModuleCode) to the STUDENTMODULE table(register the student).
How do i do this plz help

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.