Search results

This is slightly odd but was hoping someone could help me identify the key table components and fields here basically its a process of an existing system. they store data in various locations on the file system. Now want to try and move it all to DB in a structured way. i think ive identified...

what is, or does it exist, the T-SQL command to backup an MS Access database. is this possible?

what would the T-SQL be for changing (altering) the data length of a field programmatically in a table in MS Access? so if a field had a data length of 50, id like to change this to 60 programmatically. What would the code/syntax be?

in MS Access, is there a command like SQL which resets the Identity seed? I need to know this as after i remove all the records, would like the ID reset back to 0

this is a tricky one. Basically I have 3 tables country state city relationship: 1:m -> country:state 1:m -> state:city I want to get all the country, state and cities. SELECT * FROM country, state, city thats fine. But I only want to show unique values, in other words, just want to show...

Hi there. This is a different SQL Table/database I have. What I want is this: say for instance, we have 2 teams. each team has subteams. subteams can play against each other from the same team. I want a SQL query which will retrieve me: 1) team 1a vs team 1b and the opposite of that...

Hi. using SQL Server here. I have 2 tables: Customers Transactions Transactions has a "SenderID" and a "RecepientID" field. Customers contains the CustomersID's What I want to do is that, I want to pick a specific transactionID and display: SenderID, SenderCustomerName, RecepientID...

In Access, on a form, when we select lets say a customer ID from a drop down box, is there a way to automatically fill in the fields, like customer name and address based on the ID chosen from the drop down list? if so - how? thanks :)

Hi there I am trying to make a simple "booking" system. This booking system is for cars. We have customers, cars availible and the date and time and location etc... of when to pick up the customer So 4 tables i have so far: cars customers Bookings Drivers a field in Bookings known as...

In MS ACCESS, is there a way to auto increment a pri key field? I can't seem to find it! any ideas?

i have this deadline for monday and only got it issued out today!!!!! my collegue/senior had made it almost all working, it was working fine in the office, then i backed it up, sent myself and email with the attachment - and now it gives me the stupid runtime error - something like object wasnt...

hi there i am new at doing macro/vba and got assigned this thing to do. basically, we have a spreadsheet, and there are 3 rows per group. each group entry has to be copied over to a new sheet, but when copying the values from the source sheet, we need the values to be copied over to the new...

im not sure if this is a right place to post this but i would like to know what cohesion is? what do they mean when there can be a 10% cohesion and a 90% cohesion when looking at a diagram with access paths? thx :)

hi there. i am REALLY sorry if this is the wrong place to post this - i really do apologise. but i hope it is posted in the correct forum basically in my coursework, i am stuck on a question. This question says: "e) Write an outline spec for an enquiry program to support the above query" and...

hi there. i hope you can help me in a nice easy english language hehe. I am on a question in my coursework which says: "Identify all primary and foreign Key fields" now - i have made tables (on paper - there is no real database access here) and i have identified hopefully nearly all the...

hi there. in our class (not really databases) we are asked to do a piece of coursework which involves entity relationship etc... and identifying key table names and fields etc... now - if there is a many to many relationship in our diagram we have to somehow split it up so its a 1 to many -...

hi there I REALLY need big time java help for my coursework PLEASE explain in easy to understand words - im a newbie at java basically we are meant to design a program that is for a softwarehouse company it employees programmers when NEW programmers are joined to the company, an experienced...

hi there, i can't remember if I posted this, but if so, I DEEPLY apologise. I have a query which searches a label of a track via a form with a text box. what I need to know is, if we enter text in this box, how can i make the query search PART or ALL (really PART) of the inputted text. so if...

hi there. working on a project of my own. i have a main form/table with all information made a query that searches for tracks made a form based on this query made another form, with a text box and a button, so when u type in the name of the track to search for, it goes and searches it. all...

hi there. in the order form database I have, it has number in stock of product, eg 100. this figure comes from another form (so it's a subform) what i need to know is, if we order 4 (qty = 4) I know how to subtract that from the number of stock, but would it not subtract it every single time...