Recent content by thesavo

I think this maybe appropriate as it deals with modules in Access. I maintain a few Access data tools in my work flow of creating users for our info systems. A lot of the code that I write is getting converted to functions and all stored in "Module 1" of the separate ACCDB files . I do this in...

Hello, I am still green when it comes to using MS access. I am attempting to better my-self by using a recordset object instead of using DLookups. My plan is to use these for reading and manipulating data in MS access 2007. From a lot of the reading I have done, I cannot tell whether to use...

Hello. I am a user administrator for a few different information system for a state agency. I use MS access to give me the ability to make forms and reports for my workflow. This in involves Adding and removing users. But we also need to some analytical data for things like licensing. Eventually...

I have this issue too . When I add VBA code to anything, I can always crash it with dim x as Right when I tap the space-bar after 'as' is when it crashes. It started when I modified a block of code using DLOOKUP. but I have since removed all of the VBA code from that command button. and...

Ok, so you want to default it to "Mother". What if I click it after the label reads "grandfather" ?

So you have a predefined pattern you want this label to change. Mother <CLICK> Father <CLICK> Grandfather What if I click the button again after Grandfather? Do you want this label to be retained after closing the form? Do you want this label to be retained after closing the database?

Hello all, I am an application administrator for a some various companies. I find using access helps with my workflow.

You had me up-to tblProjects. Does this involve creating a relationship between tble projects and tblstaff or tblPositions And I was wrong eariler. Where each has 4 predefined ROLES each filled (or not) by a staffer of corresponding ROLE, that may or may not be a User

Thank you for the fast response. Users/staff: Yes, mostly. The staff may or may not be a user. A staff member will fill only one role, ever. But can fulfill that role on multiple projects. Staff that don't have accounts currently, in the future, have and account added or revoked. But will...

I need your advice on my ER Diagram. My data looks like this. We are tracking our projects in an application that is not well managed. I have started working on an external MS access db to track workflow of these projects in a table called ‘tblProject’ Daily tasks that I wish to accomplish...