Search results

It looks quite similar to phpbb. If you know PHP, you can change how PHPBB works to do anything you want really.

2. Are the sizes of ADP always lesser than MDB? - not always. Nothing is ever "always" 3. Do the ADP have much more speed in opening forms, running queries and generating data rather than MDB? - they should, unless the connection to your server is bad.

Look. It's on Google. Here is another.

Haha that was too easy =( I should have known that one. Thanks Ghud, mucho appreciated.

I used lowercase because that is what is commonly entered. Also, they can be formatted like 333 - 3 numbers 12G - 2 letters and a number LCO - 3 letters. I need it all to be caps if its a letter.

Did you try a search? There was a discussion similar to this on the forum recently I believe. Not sure if this is a different issue. I don't use project.

I have a form where users enter things. I want to allow ONLY Capital letters and numbers. Anyone have any ideas? the fields are never more than 3 characters long. Usually formated as such: 69k 79g 110 345 etc... Any ideas? Oh, and it has to be like this in the table, not just appear this...

What do you want to do to it? Maximize it?

You have to create a form based off the rental table. Then insert a subform based off the copy table, then a subform in that subform based off the movie table. I hope that makes sense... If you zip and post your DB I can do a fast example using your database.

The file is write protected or something? Couldn't you just get VB to keep checking permissions every few seconds or whatever until you have them, the continue on?

?? Did you get this working ok?

More elaborate - > You would have to import the file into tables. But the table would have to be in a format that is importable. Perhaps you could post some sample entires from the table so we can explain how you would go about the process.

You don't link to a text file.

Post screenshots of your report layouts. Preferably false data if needed, try to avoid blur outs, as it ruins the look of the report. I'll start.

Anyways, At this point im not sure. I've never had a problem with fields being too large, and I assume that you have your reason for not editing the record directly. However, there are limits to things, and having a giant update query that has a novel in it, is one of them, i suppose.

Why are you writing a novel and then using an update query? Why not just add it directly to the form?

I think you scared him doc. heh

hmm, usually that error comes when you miss a " somewhere. Verify your code works by just having it go into a text box. (the final code, that is). IE: Make a large text box and call it txtcodecheck then have the button or whatever do this: dim sqlstring as string sqlstring =...

Use the code docmd.sendobject to send your emails then. You can create a table of the emails you want to send it to, and select the report and click send, and code the button to cycle through the table sending the email to each person.

Wow, I didn't know #2. That's kinda crappay. lol.