marcusninja
New member
- Local time
- Yesterday, 16:19
- Joined
- Aug 25, 2010
- Messages
- 3
So I recently decided to put all of my bits for stand up comedy into a database. I thought this would be a good way to build a set script quickly and easily – the idea was to build a database using an input form with several categories (length, edginess, etc). Then I could query the database on specific criteria i.e. “bits that are shorter than two minutes, family friendly and on the topic of politics” From there I wanted to pick and choose amongst the query results which bits would go in a report and then print it out script style.
Presumably this is all possible, just not for me right now at my level of knowledge...
I have built the database and the form, but I am getting held up on the part that is supposed to make it all worthwhile. I am hoping you can help me out…
-[FONT="] [/FONT]Length Field 1 error – whenever I try to do anything I get the program asking me “Enter parameter value, Length.Field1 . If I put in a number it over-rides my database and puts that value in for every entry regardless of what I had put in before. I’m not sure what happened as it was working at one point, but broke when I noticed the name of the “length” field had only said “field1” and re-named it to say “length” I figured this screwed with the relationship so I rebuilt that, but still the error persists
-[FONT="] [/FONT]Queries. I keep trying to add criteria for a search and whenever I do this error appears: “Data type mismatch in criteria expression.” I thought it had something to do with the format of each field but they are all set to text and I am typing a text expression in quotation marks that matches the field entry exactly.
-[FONT="] [/FONT]Reports – I want to have title and length o the bit on one row, then in a row below it, the body of the bit in a column all to itself, so it’s not wasting a bunch of space by having all three columns on the same row. This would then repeat for the next bit in line. I can’t figure out how to do this – is it possible?
-[FONT="] [/FONT]Length field – for some reason it won’t let me put in decimal places in the length field's numbers. When I try to change the format of it to decimal in design view, it says I have to delete relationships first. I deleted its relationship and I still got this error. Again, this was working before I changed the name of the length field. I dunno what I broke.
-[FONT="] [/FONT]Forms – In the area of “category” and “style” and “audience” I would like instead of a drop down list, a checkbox style one, where you can specify multiple values. For example under “style” I might want to organize a bit as “absurdist” and also “story-telling” so it can be queried under both of those values.
I am using Microsoft Access 2007 on a Windows computer. I have uploaded the database sans the meat of the bits to rapidshare if you want to take a look: http://rapidshare.com/files/415296390/Joel_Buxton_Bit_Database_HELP.accdb
Any help greatly appreciated. Please remember that I am VERY new to database programming and might have difficulty with a lot of specialized language.
Thanks for helping a noob!
Joel
Presumably this is all possible, just not for me right now at my level of knowledge...
I have built the database and the form, but I am getting held up on the part that is supposed to make it all worthwhile. I am hoping you can help me out…
-[FONT="] [/FONT]Length Field 1 error – whenever I try to do anything I get the program asking me “Enter parameter value, Length.Field1 . If I put in a number it over-rides my database and puts that value in for every entry regardless of what I had put in before. I’m not sure what happened as it was working at one point, but broke when I noticed the name of the “length” field had only said “field1” and re-named it to say “length” I figured this screwed with the relationship so I rebuilt that, but still the error persists
-[FONT="] [/FONT]Queries. I keep trying to add criteria for a search and whenever I do this error appears: “Data type mismatch in criteria expression.” I thought it had something to do with the format of each field but they are all set to text and I am typing a text expression in quotation marks that matches the field entry exactly.
-[FONT="] [/FONT]Reports – I want to have title and length o the bit on one row, then in a row below it, the body of the bit in a column all to itself, so it’s not wasting a bunch of space by having all three columns on the same row. This would then repeat for the next bit in line. I can’t figure out how to do this – is it possible?
-[FONT="] [/FONT]Length field – for some reason it won’t let me put in decimal places in the length field's numbers. When I try to change the format of it to decimal in design view, it says I have to delete relationships first. I deleted its relationship and I still got this error. Again, this was working before I changed the name of the length field. I dunno what I broke.
-[FONT="] [/FONT]Forms – In the area of “category” and “style” and “audience” I would like instead of a drop down list, a checkbox style one, where you can specify multiple values. For example under “style” I might want to organize a bit as “absurdist” and also “story-telling” so it can be queried under both of those values.
I am using Microsoft Access 2007 on a Windows computer. I have uploaded the database sans the meat of the bits to rapidshare if you want to take a look: http://rapidshare.com/files/415296390/Joel_Buxton_Bit_Database_HELP.accdb
Any help greatly appreciated. Please remember that I am VERY new to database programming and might have difficulty with a lot of specialized language.
Thanks for helping a noob!
Joel