Search results

Hi Guys I have written the following piece of code that will check if the phone number is numeric or not . But I want to add another check in this so that if there is a space in the phone number then just ignore it . As normally there is a space after postal code so my current code doesn't...

Hi Guys I am trying to write code that will change font color of the label on mouse move event of that label. It works fine but I also want to write code to change the color back to grey when mouse move event doesn't occur on that Label. SO basically changing fontcolor to red on mouse move...

Thats great, Many Thanks arnelgp. :)

As i don't have any date field so I want to check if today is any day between Monday and Friday then store this value otherwise a different value.

Arnelgp, here is new field in a query and when i run it then it asks me enter Date value : Daily_From: Switch(Format([Date],"ddd")="Sat","9:00",Format([Date],"ddd")="Sun",Null,True,"8:30")

JDraw, there are 2 fields which are not in a table and I don't want to store in a table infact. So i thought of adding 2 expression fields in a query itself and display the values within those based on todays day. If its between Monday to Friday then store values 8.30am and 8pm ..else store 9am...

Hi Guys I am writing a query that will display data from a table. Along with the fields from the table, I also want to add 2 more fields in a query which are not there in a table and it will check what day is today and if the day is between Monday and Friday then show in new fields say...

Thanks Moke for all your help. :)

Thanks Moke , I have written the following code . I am getting an issue when trying to export the query result . Looks like it doesn't like strsql in below highlighted statement. If I change strsql to inbuilt query name then it works fine. SO how can I make this bit working. Thanks strsql =...

Hi Guys I have a listbox that stores all Campaign types. Its a multiselect listbox so when I select multiple campaign types from the listbox then I want to add that filter in sql statement. How this can be done. I have tried to write code but it doesn't work. ANy help will be much appreciated...

Yes i did go through the import text wizard but no specifications were showing in that.

Sorry actually what happend is when i ticked checkbox 'Import/Export spec' and clicked OK. and when i went back again then it was deselected . Trid it couple of times but still the same error message :(

I have added the specification as you suggested but still getting the same error message. Any ideas| ?

Sorry how can i import the specification ? Can you pls elaborate? The other project is created by my manager and I have taken the code from him but got stuck at this bit. Thanks

Hi Guys, I am getting runtime error '3625' at the docmd.transfertext line . The error message says "The text file specification 'Campaign Import spec' doesn't exist. You can't import,export or link using the specification. " The same code for my other project works perfectly fine. Public...

1. created an unbound listbox control named lstChoice 2. populated with list of options 3. moved the related label to above the lstChoice- ensured bottom of label is touching top of lstChoice 4. set the height of lstChoice to 284 (0.5cm) 5. in the lstChoice mousemove event put something like...

Thanks Guys, I was looking for this thread and couldn't find it yesterday. Somehow it got deleted.

Gasman, I already made the text scrolling across. Just wondering if this is what we need as below and timer along with it. Its really amazing :) DoCmd.NavigateTo "acNavigationCategoryObjectType"

Thats great Ridders. Sorry one more thing have we used windows API to do this? or is it Access function to scroll marquee text and we have just added timer?

Ridders, Can you pls check whats causing the issue? I have tried changing the timer and making width of textbox bigger but it still scrolling to small space...