Recent content by elbweb

I know its been a while, but i really need some help. I want to know how to strip special characters (like Alt + 785, etc) from a string/textbox. All the help i get tells me to check the ascii values - but they dont have ascii values, in code the only thing i can see is a '?' and when i check...

ok here it is, its a pretty simple main form that has data entry and searching capabilities.. it shows how to use search strings for dates and how to say in a term is contained, if its absolute etc.... i dont have much time to explain, but if you can't figure something out, feel free to ask in...

another thought, have you ever put any code within the sub form? it might need to be registered so that you can call it within code... i dont think thats the right way of saying it but, a simple way to check is within the VBA screen, do you see it on the left, the subform i mean, if you dont...

change the format of the field to a date time, with the specified time format you want, it should then give you the right answer, if not youll have to do code to run through it.

another choice would be to manually insert the data into the database, for example have a button that says "Copy From Excel" and have that button parse the clipboard and insert it into the database, and then call whatever else you need to be called after that update.

heres something that it hink would help, since it is a sub form, it is still a form, and therefor can still be called by the form name, so if the sub form name is MySubForm, then you can just use the MySubForm as the string and it would work fine, would it not?

its really simple to try and create a form like you are saying, i have created one for someone else on this forum, but i dont have it at my fingertips now. i will try to get it on the site asap, if you would like, also, pm me to remind me.. :P but if you have any questions regaurding it.. feel...

sorry if this is a little late, but whats the problem? are you sure the fields and everything are what they need to be? check the WHERE part of the sql string, and make sure that there are NO differences between the table designs.

hey, i would first like to appologize, but life/works just been overwhelming lately and i can't get on here as much as i would like. you say you are one step from getting it finished, what is it thats not working? is this the else statement? what are you trying to do, what do you expect to...

hope you have fun with work :) and feel free to pm me if i'm not around and no one is answering your questions, that seems to be the only way to get my attention ...

i hope that if you are asking this you know a little bit about SQL, but i threw together a quick query that pulls all of the Records from tblTemp where Updated is less then 1 day ago, and OpenClosed = "Open" You could turn this into an update query if you wanted to (i.e. to change a flag field...

...stupid duplicate post...

well i might have something that could interest you, a little bit ago i posted a good example of how to use and manipulate recordsets, maybe you will be able to find there what you want/need as always feel free to come back if you need some more help...

is this part of a datasheet? try doing it within the design of the table, then maybe it should be carried over wherever the data is bound.

banana, i will leave that one for you,the only time i ever tried to get a cross tab query to work it blew up on me and i have avoided them ever since, forgot they existed, but i think that shoulds about right.. i tried a crosstab query wizard real quick and don't know how to make it work for...