ChrisPadgham 113 Posting Whiz

I think the object of school assignments is that you do them yourself

ChrisPadgham 113 Posting Whiz

You are best to use a mac. Download xcode and start from there. there are some excellent tutorials on iTunesU

ChrisPadgham 113 Posting Whiz

Create a dataset using a SQL statement to combine your multiple data and then use this as the recordsource for the datagrid.

ChrisPadgham 113 Posting Whiz

No

ChrisPadgham 113 Posting Whiz

No switch takes an integer you need if then else if construct

if ([textfield.text isequaltostring:@"someCase"]) {
    // do something
} else if ([textfield.text isequaltostring:@"anotherCase"]) {
    // do something else
} else {
    // do yet another thing
}
ChrisPadgham 113 Posting Whiz

That is not a label that is a text field. Drag a label across from the object library, it will have type of UILabel. If you are using the latest version of xcode you should be putting an underscore on the front when referrring to them locally,

[_label setText=@"Hello World"];

or

self.label.text = @"Hello World";
ChrisPadgham 113 Posting Whiz
NSArray *dateFormats = [NSArray arrayWithObjects: @"dd/ mm / yyyy", @"mm / dd/ yyyy", nil];

NSString *selectedDateFormat = [dateFormats objectAtIndex:formatSelected];
ChrisPadgham 113 Posting Whiz

Yes, you do not need to synthesise them if the setters and getters are as simple as above. In recent versions the "_" on the front is for the internal representation of the property. You also do not need the statements on lines 3 & 4.

Properties are the external attributes of you class coffeeShop. When you create an instance of this class you can then set these properties.

`

coffeeShop *myShop = [[coffeeShop alloc] init];
myShop.coffee = @"arabica";

`

ChrisPadgham 113 Posting Whiz

I would check out the Stanford Uni lectures by Paul Hegarty on iTunesU

ChrisPadgham 113 Posting Whiz

This thread is closed, please start a new one. Also you I believe you have the information you need above. It is for you to write the code.

ChrisPadgham 113 Posting Whiz

The chart wizard in Excel should be all you need. just add a chart to your spreadsheet and step through the wizard

ChrisPadgham 113 Posting Whiz

on line 16 you should have

[QTY]=[QTY]-@QTY

however it looks like the employeeId is the primary key to Inventory file which seems somewhat strange.

ChrisPadgham 113 Posting Whiz

see here Click Here

ChrisPadgham 113 Posting Whiz

if you are using ARC then yes

ChrisPadgham 113 Posting Whiz

you can probably buy VB6.0 on eBay. .Net is available for free from the microsoft website.

ChrisPadgham 113 Posting Whiz

if you double click on the control it should generate the appropriate handler for an click event.

ChrisPadgham 113 Posting Whiz

I presume you are talking about IOS,you need to investigate core-location and map kit however as of the release of IOS 6 a few days ago Apple is using its own mapping not Google.

ChrisPadgham 113 Posting Whiz

Nothing really it is just a matter of personal taste, you can use either as you wish.

ChrisPadgham 113 Posting Whiz

I am not sure why you have declared input and i as arrays, this seems wrong. and the * before i in two spots on line 11 should not be there. an int is a primitive of the language and not referenced with a pointer.

ChrisPadgham 113 Posting Whiz

so what has this to do with VB6

ChrisPadgham 113 Posting Whiz

you could perhaps add another column called "selected" to your employee table which is a Yes/No value that users can check. Then have a piece of SQL to insert the employee ids of the selected values into the other table, somethings like

INSERT INTO newTable (EmployeeId) SELECT EmployeeId FROM Employee WHERE Selected=True
ChrisPadgham 113 Posting Whiz

it looks very much like homework you should be doing yourself.

ChrisPadgham 113 Posting Whiz

the if statement does not make a lot of sense it probably should be something like

if not isnull(datagrid1.col(0)) then

or

if datagride1.col(0) <> 0 then
ChrisPadgham 113 Posting Whiz

if there are 7 rows there is going to need to be 7 addnews one for each row with an id of 1 2 3 etc and scores from each text box.

also you might like to consider using SQL INSERT statement to insert the rows rather than an addnew.

ChrisPadgham 113 Posting Whiz

If you don't know how to create a module, I suggest you take a tour of vb first and get an understanding of how VB works prior to commencing such an abitious program.

AndreRet commented: Agreed!! +12
debasisdas commented: agree +13
ChrisPadgham 113 Posting Whiz

You could do this but you probably won't want to. Word is not designed for storing data and really excel isn't either. Store your data in a database and use word or excel to display it.

ChrisPadgham 113 Posting Whiz

This is not normalised properly, Time, Date and Day should all be housed in the one field using a type of Date/Time. When you display them you can choose to display the one field three times for each of the values.

ChrisPadgham 113 Posting Whiz

you already asked this on the VB.Net thread which are you using

ChrisPadgham 113 Posting Whiz

post some code and the error you are getting

ChrisPadgham 113 Posting Whiz

I think you are jumping the gun here, for example the decision to save your records is a decision for the technical design. At this stage you don't really even have functional requirements tied down, let alone a functional design. Start with a needs analysis, ie a detailed understanding of the need you are trying to address and from that derrive the functions that the software must perform. You can then start looking at how you are going to implement those functions technically and I am thinking it is probably not going to be a text file. Unless, of course, this is a student assignment in which case you should be writing it yourself.

ChrisPadgham 113 Posting Whiz

This is set up in your SQL at line 9 above.

SQL = "SELECT * FROM someTable WHERE Field1='" & textbox.text & "'"
ChrisPadgham 113 Posting Whiz

I presume you have solved this by now, but you need to shift the declaration of the object from the button press event to the .h file. Also declare it as a property if you want it a publically accessible object.

ChrisPadgham 113 Posting Whiz

Have you tried something like below

frmDisplayLockerInfo.TextBox5.Text = DataGridView1.Item(7, i).Value & ""

I am not on a PC with a .NET environment so you may need to test it but it is the way I usually address this problem in VB

ChrisPadgham 113 Posting Whiz

if you want all of the dates between two dates you will need an array or collection to house them, a single variable will not do.

use the DateAdd function to iterate through the dates

aDay = dateadd("d",1,datehired)
do until datediff("d",aDay, dateend) <=0
    'add date to array or collection
    aDay =dateadd("d",1,aDay)
loop
ChrisPadgham 113 Posting Whiz

Just at a glance I think you should move msgbox "Report Complete" to the next line. Generally speaking in VB if you have it on one line it is viewed as a complete statement hence the first else if is not considered part the statement.

Alternatively move the ElseIF to the end of the row after "Report Complete"

ChrisPadgham 113 Posting Whiz

If you just want a csv file you don't need excel.

open "c:\datafiles\homers_lineup_wk_1" for output as #1
write #1, var1, var2, var3
close #1
ChrisPadgham 113 Posting Whiz

barcode fonts are quite tall are you sure your UILabel is tall enough

ChrisPadgham 113 Posting Whiz

you usually use Touch Up Inside for a button press event.

ChrisPadgham 113 Posting Whiz

You need the nil to indicate the end of the list. Also float is a primitive data type and so wont work in this context. You should use NSNumber (which is an object) rather than float.

ChrisPadgham 113 Posting Whiz

if [Tour Id] a number, if it is you should not have the single quotes in the the expression

strSQL = "Delete From Tour Where [Tour ID] = '" & fgdTour.TextMatrix(fgdTour.Row, 1) & "'"

ie

strSQL = "Delete From Tour Where [Tour ID] = " & fgdTour.TextMatrix(fgdTour.Row, 1) 
ChrisPadgham 113 Posting Whiz

the view out of MVC is the GUI. it is basically about separating the data model from the user experience, with the controller managing the interaction between the two.

ChrisPadgham 113 Posting Whiz

Here is a link to some free unicode controls for VB6 they may help,
Click Here

ChrisPadgham 113 Posting Whiz

check to see if you have a default value specified, both for the textbox and for the field in the database

ChrisPadgham 113 Posting Whiz

if may work for the first 14 days of the month but if it is currently 20th of June then adding 15 will give you 35th of June which not many people have as a birthday. Try adding 15 to the getdate with the dateadd function before using day function DateADD reference.

You will need to use it for both getdate calls.

adam_k commented: I agree +0
ChrisPadgham 113 Posting Whiz

what part of Oracle are you interested in

ChrisPadgham 113 Posting Whiz

Can I suggest you try toad.

ChrisPadgham 113 Posting Whiz

please post your datamodel

ChrisPadgham 113 Posting Whiz

esorison, please start a new thread if you have a question. and you need to supply more info than above if you want a good answer

ChrisPadgham 113 Posting Whiz

try something like

Set fso = CreateObject("Scripting.FileSystemObject")
path = "C:\folder1"
fso.createFolder path
ChrisPadgham 113 Posting Whiz

Just map the drive with the database on it to each computer. Link the tables from that database into your application.