Recent content by ck4794

I've been searching for days to find this information. We use common access cards, also called smart cards, to access our computers. What I would like, is a button on a form that would insert the name from the current CAC. All of my searches are resulting in signing a database as a whole...

I think a lot of threads start this way, but this seems like it should be simple. I want to programatically, through VBA, download an outlook folder into a table in access. From my reading, it seems the best way to approach this is for the multiple users to set up a folder with the same...

so i've bastardized some code together, as follows: Const m_strFieldFileName As String = "FileName" ' The name of the attached file Const m_strFieldFileType As String = "FileType" ' The attached file's extension Const m_strFieldFileData As String = "FileData" ' The binary data of the file Sub...

So the basic Idea of my database is a tracking system for personnel. There are two statuses, active and inactive. So these people are required to submit certain forms, and they get "lost" a lot so i started attaching them to their profiles. recently i went to a new system of organization...

on the macro builder, click "show all actions" and then the setvalue macro will be available. i would do this through an if statement. ie: after update if (your combo)="uk" then set value (whatever object) else if... if you need more help ask. word of warning access finds this macro...

ran into a new problem today. i used this same process on another part of the db. Background. I have a list of "members". There are three lists of members I want to maintain. "Active" "Inactive" and "Checked Out". I think that's fairly self explanatory. My earlier problem was going from...

the queries were drawing from the form, so if i closed it first i would get "access can't tell its asshole from its elbow" kind of errors

not a clean fix, but i found one. all this was from a button click. so in the macro builder for the button click, i added an on error statement, which was go to next. the next statement is close window, don't save. it works.

So this is the code from the underlying table. (Access built all this for me. I'm familiar with the concept of the codes, but not fluent enough with the syntax to write it in code. I use macro builders and query builders). SELECT [tblProfile/Master].ID, [tblProfile/Master].Last...

well yea it's doing something with it, if i knew WHAT it was doing we wouldn't be here hahaha. ;) just giving ya a hard time friend, thanks for speaking up.

working like i want- Step one: Use a form to search for the record I want (I've tried using the table itself as the source, and an independent query) step two: once the appropriate source is selected, click a button, which saves record (there's a date to update from here) and then open a...