Search results

Wow! That made a huge difference. Indexing alone wasn't enough. I had to change the logic of the SQL to get the results I needed. Thanks a lot!

I have a form that uses the following join as its control source:SELECT * FROM [Purchase Order] LEFT JOIN [Work Orders] ON [Purchase Order].WorkOrderID = [Work Orders].WorkOrderID; I also enclosed a small picture of the relationship between the two tables. This is the problem I'm getting when...

I have a table with a rotating work order number (from 1 to 9999 then starts over) and because there may be more than one record with the same work order number I need to find the most recent one. Here's the query I'm using the find the most recent record for each work order number: SELECT *...

I know what I did wrong. I had an enumerated type as a parameter and I changed the enum declaration but not the parameter. So one of my parameters was of a non-existant type.

I don't know what I did, but when I'm typing code it no longer autocompletes or gives me the drop-down list of options. When I'm typing a function I don't get the parameter description tooltip either. This only happens in one of my databases; the others work like they always have. If I type...

A man walks up to his house and sees a snail crawling on his walkway. The man picks up the snail and chucks him over his house. Three years later the man is walking up to his house and sees the same snail on his walkway. The snail looks up and says, "What the fuck did you do that for?"

I'm actually inclined to agree with you on this one Banana. Without a primary key my other tables will have to use two foreign keys (orderID,date) to get the right work order. Plus, if I use the primary key the other tables can store that instead of the orderID (which I could find out thru...

Whew, once again I have to try and get on board with what you're saying. Intuitively I would've guessed it's better to create a composite key with what you've got rather than add an extra field for a primary key. So are you saying I should use some unique number (from 1 to infinity) apart from...

Hmm, with that in mind do you think it would work well if the number kept repeating (1 to 9999) and when the number comes back around old records would be overwritten? Backups will still be made of course. Each record has a date field, so Date + ID = Primary Key 4 Life.

This is a lot more complicated than the title suggests. I was asked to reset the work order numbers used by the maintenance department. When they reach work order #9999 they want to start over. My best bet is to make a backup of the tables and create new ones that include the last 2-3 weeks...

It's very annoying because it's very short. I don't usually timeout while browsing, but I almost always timeout when I'm trying to post a new thread. I mostly use the forum at work and I don't want to save my login information on this computer.

Ugh, very simple error. For the main Form I had "Allow Edits" set to No. I actually could've swore I saw that already and fixed it. I was able to enter data in every other control so I didn't really think that could be the problem. Thanks for you patience and dilligence Banana.

Okay, well I wasn't planning on having a ChildID but otherwise I imagine the whole record would be the primary key. So given I use structure 2 and give the 2nd child table a proper unique ID can you see why my subform would be blank like this? I mean, this doesn't sound like an unusual...

First off, thank you for your patience, because we're obviously not on the same page here. Now, if I read you correctly you're suggesting a table structure like 'structure1.jpg'. And what I'm suggesting is a two table structure like 'structure2.jpg'. Now let's go from there...

Okay, technically speaking I don't need a 2nd table. That's how things were originally set up, but it was inefficient. A reservation is made for 1-2 adults and 1-6 children and special data must be kept for each individual child. So it's either have one table with a lot of blank fields (not...

This is the basic layout of the tables: Reservation Child =========== ===== *ID ~ID *ReservedBy ~ReservedBy FirstName FirstName LastName Age PhoneNumber Interests DinnerDate Location AdultsAttending ChildrenAttending The...

Well, if the master and child link fields are blank it will show all records, not just the ones where the foreign keys match the primary keys. Maybe I should start from scratch. The old form worked but it didn't use a subform because the person before me knew nothing about databases and...

I have a subform (in form view) in a form that is used for data entry. When I open the form the subform is blank except for the navigation controls. The navigation controls are disabled though. If I switch to datasheet view I will see the column headers but there won't be any place to type...

Well, I'm just the database administrator, not the network administrator. I was mostly curious if Access is capable of such operations. If I understood what you were trying to say, I think the answer is no. However, I believe the ftp security is actually insufficient enough to allow such an...

Client-side scripting shouldn't have file writing/reading capabilities for security reasons. I highly suggest you stick with Access forms or use ASP. If you really want to use a web browser for entry then do a google search for "fpdbform.inc". It's pre-made code from Frontpage and it should...