Search results

I am designing a database, and entry forms concerning some staff issues at work. Each site (33 of them) has to submit a weekly report. What makes each record unique is both the site location and the week. After thinking about the logistics of trying to always link those two fields, I...

THANKS! I was mulling this problem last night while mowing the lawn (I like mowing the lawn because it is about the only time I'm not trying to do 6 things at once and it lets me THINK!). Besides, I have a John Deere mower. <grin> If I create a unique name for each record, it is really the...

Would it be proper to assign each record a unique name? Create a field called ID? It could be a combination of the Facility name and the date? For example, ABC092502. If I did that my subform problems would be solved, but I didn't know if that could become cumbersome at some point. Next...

Okay, here is the code excuted when the button is activated: Private Sub Staff_Injury_Click() On Error GoTo Err_Staff_Injury_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Staff Injury" stLinkCriteria = "[Institution]=" & "'" & Me![List85] & "'"...

That doesn't seem to work. THe subform is accessed by a button, and there don't seem to be any controls for specificing the view. When I actially open the subform as a form, it opens as a data sheet, but not when accessed with the button. I went throught he properties, and selected no for...

My subforms are designed in datasheet view, but when I access them with my buttons in the main form, they appear in a standard column view. How can I set the controls to preserve the datasheet view? Thanks. Gayle Ann

I'm designing a form where the user (my supervisor), would like to know the percent change from the previous week. One of these areas is overtime. I have a field, OTHours. How can I reference the value form the previous week's weekly report so that the I can note the percentage change...

I haven't done "real" programming in several years, and then it was in 97 (job transfer, new duties). I did basic things, but nothing advanced. I'll let you know about more advanced thigns in a few weeks <grin>, but I have to say that I prefer XP for the routine things. I like the changes...

Okay, what if I have a linked table? For example, one of the question is Type of Drugs COnfiscated, and Location of Confiscation. What I see is a table with 3 fields: Facility Date Type of Drug Confiscation Location Facility would be the primary key, with a relationship to the main table...

Access/Excel Record Exchange This post is my first on this BB, so please forgive any etiquette errors. I work for a government agency. I have an Access database for one of the weekly reports that each site is required to provide. If Outlook allowed sites to send Access databases, there...