Recent content by Cradders

Hi guys, Long time no post - that's cos my database has been working wonderfully. now I'm trying to tweak it with new stuff and again running into trouble. I've added a column to my invoice layout. to add an additional markup against itms. This references another field where I type in what...

Um, I'm trying to remember what they all were - I just took any validation criteria off. Some of them were: Always Validate, don't allow user to override during data entry, Validation by: not empty, member of value list (drop-down list containing criteria that matched the rows in excel I...

Hiya, I guess I'm a complete database eejit - I had a good old look through 'define database' and I had changed the validation rules on some of the fields I was importing into. I took all the validation criteria off and - hey presto - it imported perfectly. Sheesh! I wish the software came...

I have just realised that it is actually giving me an error message - The import Records Summary reads: Total records added / updated: 141 Total records skipped due to errors: 141 Total fields skipped due to errors: 0 So obviously I'm doing something wrong, but I can't for the life of me...

Hi guys, Here's another curly question for you. I'm importing data from an excel spreadsheet into my database. I've done this before into the same database and it's worked perfectly. This time, it goes through the whole process, says that it has successfully imported 147 records, but where...

Hi Jean, I gave that a go but it came up with an error: "There are no valid criteria in this request. Type a valid request before clicking Find." Where is the option to Go to related record and Show only related record? That sounds like what I want but I can't find this option. Am I doing...

Sorry Jean W, Not being a programmer I don't quite understand you - could you be a little more specific? sorry for being a database spaz! [ponder]

Er, I've just realised that the PDF and Print scripts I've made do only select one record, but it's the FIRST record, not the record I was in when I hit the button to perform the script. So obviously I'm lacking the bit where I tell it I only want this current record to show while the script...

Hi guys, I'm getting pretty fandangled on this FM thing now... so much so that I've gotten out of my depth (again) and need your trusty help. On my Invoice data entry form I have added a button "Preview Invoice" which I want to go to the 'Print Invoice' layout and show the details of the same...

How do I express the concept "does not contain data" or "does contain data" within a calculation: ie, within an If logic test, I want to insert text in a field If another field does contain data. Sorry I know this is probably really basic programming 101 but I'm not a programmer! Thanks...

I found the answer elsewhere - this is a bug. You have to set the JPEG to RGB, not CMYK and then it works. V silly!!!

Helloo I've been importing data into my database to test it and now it's ready to import the real data, but i want the serial numbers to go back to 0 so it's like a brand new database. How can I reset them? I've emptied all the records out of it, and I'm ready to import the real data...

JeanW, I don't have a manual... Is it difficult to explain what I have to do? ?? Cradders

Hiya, Is it possible to do this? Logically it seems it should be but it doesn't want to work. Within my product catalogue table I have a field called "Description". In this table there is a field for "Product Type" which is a value list, one of the choices being "brochure". Under the...

Well this is a curly one guys. I've got an image (it's our letterhead banner) which I'm using on a layout (Estimate) that ultimately gets exported as PDF - so it looks exactly like a normal estimate printed on a piece of our company letterhead. On the layout it looks fine. When I export it to...