Search results

Good day developers! Small question. I have a table with employee names, ID's, etc. When an employee logs in, i take the username from that table and put it into a global variable so i can use it in my switchboard (well at lease i am trying to use it in my switchboard). On the bottom of my...

this is beginning to be a headache for me lol. yes i am using 2010 you lost me on that one dave. there is no code at all, strictly macros and i see nothing named 'handlebuttonclick' macro. do you mean buttons for the 5 reports that i am trying to direct the user to? i am so lost and i dont...

the later - basically it is not doing what i want it to do (opening the switchboard page)

here you are

can i send it to you in a PM instead?

the whole database? or just my VBA code? there is alto of sensitive documents and information in it that i am forbidden to disclose so i shall be careful in what i let out.

bob, i do not see this 'HandleButtonClick()' procedure anywhere. my switchboard has no code (all macros) and as i said above, it will not let me automatically convert it to vba. I AM STUMPED!!!!!

First of all, thank you for the time you are putting in to help a complete stranger. it is nothing less than appreciated :). Second, my switchboard commands (on open and on current) are all in a macro (from when i used the switchboard manager). would that have any effect on directing the user...

Alright, so dropping the [ItemNumber] does not work and neither does compacting the database. i have tried with all database pages and still nothing. Also i have run into another problem. The titles no longer change when you move to another switchboard like they used to. They would normally be...

i turned it into a pdf file and had to remove certain names for security purposes. layout and numbers have not changed

I don't see what is wrong here. your code seems like it should work but it still gives me a blank switchboard page

i tried to add your code(copy and paste) and i still have the same "error"

Alright, i have a slight problem with that lol. I inputted the code and when the user hits ok, it takes them to the switchboard page but no data shows up. it is basically a blank switchboard page. my code is identical to yours except my switchboard id is 6. I also tried putting that code in...

I actually changed it to a DLookUp function and it works fine now. But thanks :)

sorry if this has been asked already - I have a db that, on opening, prompts the user to check any expired (or soon to expire) documents via text box. if the user clicks no, nothing happens, if the user clicks yes, i want it to go to the switchboard page that the soon to expire documents is...

sorry if this has been asked already - I have a db that, on opening, prompts the user to check any expired (or soon to expire) documents via text box. if the user clicks no, nothing happens, if the user clicks yes, i want it to go to the switchboard page that the soon to expire documents is in...

thanks all for your help. i just downloaded the sql server and will try it out now.

strempID is populated by me in a table that is currently unlinked from all others (i mean like no relationships and junk) here is the full code so you can get a better understanding of what i may be missing:

just a question. if a copy of the database must be stored on a shared drive, what purpose does sql server or oracle serve? can they not still attempt to access the copy on the shared drive? i am simply trying to protect sensitive documents/materials. as for hackers, i dont think i have to...

i was wondering if that is a whole seperate development platform . so you mean once the db is seperated to front and back end, i would store the back end in that sql server?