Lumpy
Last Activity: Dec 21 '10, 04:54 AM
Joined: Oct 8 '07
Location: Wisconsin, US
-
Worked like a Charm, Thanks a million Ken!... -
Missing operator in DLookup function help
Hi all,
I am having a problem with a line of code in access vba. I am trying to use the DLookup function to check whether or not a record already exists with a dealer name. Once I know if it exists or not, later on in the code I will run some sql to either insert a new record or update an existing record. But, I am getting a syntax error that says I am missing an operator. I have googled around but to no luck, any help would be much appreciated.... -
Never Mind all,
I figured it out. My partner, who doesn't, well I should say isn't supposed to be messing with the programing end of things decided to set that field to have a default value and that is why it was coming up the way it was. Funny guy :D
Thanks anyways!Leave a comment:
-
Reset Form Variable w/ Each Record
Hi All,
Let me just start by saying that this isn't a big deal, I did find a way to get it working, but I was just wondering what the "correct" way of going about this is.
I am using access 2003 and have designed a form to use for customer quotes. At the beginning of the form I declare a variable to be used by the whole form, something like, public disprice as integer, and then once a discount field is filled in,... -
Xampp comes with Mercury mail server I think it is. Configure that and make sure that it is running and working. To accomplish this, I would check out the website or something, I don't really know what would all have to be done for this part.
Once that is done, you may also want to verify your mail function settings in the php.ini, that they match up with your mail server.
After that, if the mail server is functioning,...Leave a comment:
-
Hey, no fair...you didn't say that in the first post.. :D
So, you are displaying something like 25 per page or something like that? I don't know the code your using, but is it possible for you to pass the variable, or use a variable that you are already passing to setup your counter?
I guess the question I have for you is how is your script knowing what part of the list to display, and is it possible to use that info...Leave a comment:
-
If your looking just to download the script from someone else than I would type "php script to Accept the Terms & Conditions" into Google and go from there. Plenty of sites like hotscripts.com come up and you can search through what they have and go from there....Leave a comment:
-
I think you should be able to just use it telling it what dimension to look in. It's kind of hard for me to put this one in words, so let me just show you a quick example...
[CODE=php]
$test[0] = array(1,2,3,4,5 );
$test[1] = array(6,7,8,9,0 );
echo max($test[0]); ///would output a 5
echo max($test[1]);///would output a 9
[/CODE]
You know what I am saying here? By telling it to look in dimension...Leave a comment:
-
You might want to try a foreach loop, which can go through all the variables in the POST array and insert them.
Something like...
[CODE=php]
foreach ($_POST as $key => $value) {
///SQL insert code here
}
[/CODE]
Try that and if you still can't get it maybe post some code and we can see if we can help troubleshoot the code with you....Leave a comment:
-
I am assuming that when a new score is entered, it is getting stored into the table, and then the query runs again and prints out the scores. In order to print out the scores you must have some kind of loop that you are using to keep cycling through the table to get all the entries. So can you just set up a variable to count for you, and just echo that variable in the place you want the number to appear.
Start out with...
...Leave a comment:
-
I am not sure if I completely understand what you are wanting to do, but anyway to answer what I think your question is, yes you can do something like that.
You would want to setup your memo variable something like this....
[CODE=php]
$memo[] .= $_POST['memo'];
[/CODE]
And that will create the array variable $memo and add each entry after the last one. So the first key in...Leave a comment:
-
The only other thing that you would be able to do is to take on a partner with this kind of inside knowledge, and possibly customers. When your starting a business like this, it isn't always the most ethical of choices to steal customers but one thing I did with my old boss was to divert incoming customers the last couple of months that we stayed with the business we worked for. We told the incoming customer what we could do for them and how much...Leave a comment:
-
Thank you for posting some code, it makes it easier to see what the possible problems could be.
First thing I saw is on line 11 you have an extra ">" after, action="email.p hp">. You don't need that because you will be closing the form tag off after the php is complete.
The second thing I saw, and maybe I am just missing it, is if the form passes and goes to the confirmation part, there...Leave a comment:
-
Without seeing the code form both pages, the form page and the email page, it is tough to say why the post variables are not being emailed to you.
Reading through your post, I did wonder if upon confirmation and final submittal to the email page if the email page is looking for the right post variables. But that is really only a guess without seeing the code for both the pages you are using.Leave a comment:
-
An easy way to do this would be to put a variable into the url. Redirect to something like www.domain.com/whatever?page=a and then in the first few lines of the target page, put in a few lines of php code that will load the right content.
[CODE=php]
<?php
if (isset($_GET['page'])) {
///code to get right content
}
[/CODE]
Simple and effective...goo d luck!Leave a comment:
-
So, I got the problem solved. I was in the process of making some screen shots that I would be able to post, so you would be able to see what I was doing and what I meant by the problem I was having. When I noticed a little pattern. When the lines showed up in the overall png, It matched up with another part of the site, in which I am also using the same process to make the background. Noticing this I examined the code from both files again, and...Leave a comment:
-
GD Functions leaving lines in graphics
Ok all, I have a question regarding the gd library in php. First, let me say that there is really no reason why I am doing this the way that I am. I was a little bored with doing homework and thought to myself, hey I wonder if I can put a background images into parts of a webpage using css pointing to php files. So I set out to answer the question that was burning away at me... :)
Anyways, here is the code I am using to create the... -
Your Welcome, glad I could help! :D...Leave a comment:
-
I would just set that rand expression to a variable and put the variable into the echo statement...
[CODE=php]
<?php
$somevar = rand(1,5);
$HEADER = "...
<img src='".THEME."i mages/header_left$somevar.jpg' alt='left slice' class='left' />
...
?>
[/CODE]Leave a comment:
-
Thank you debasisdas and RedSon for your responses. I just felt a little weird about submitting something like that, so that is why I asked.
Just to give an update. The code I did submit, which wasn't used on any professional projects must have satisfied their needs though. They already called for an interview and testing of my knowledge....So hopefully now I just don't blow it :DLeave a comment:
No activity results to display
Leave a comment: