Search results

I've been thinking about this some more, would this be the right way to go about it. Say in my work_hours_tbl if I add a 'active' field, and then in the query that dumps to the temp table. Have it only grab the ones marked active? Then when I make the changes to the ones in the temp...

Been thinking about this, and how to go about it. So create an append query from my work_hours table, and move them to my temp table. How do I filter out only the current work period entries, to move them to the temp table? for example in my work_hours table I'll have many entries for...

ah OK, that seems to work. does anyone have any ideas how to make the updating of the staff schedules any easier? Maybe a way to automate the upcoming weeks schedules, to duplicate what's already there for the next week, and then she can just go in and modify the ones who actually change...

I've been toying around with this a little using week numbers. I have 3 queries The first query gets the week number for the employee schedule using this on the date Expr2: Format([start_date],"ww"). I then have a second query that gets the week number of the event (calling in sick etc)...

I thought about using week numbers, but was hoping to avoid it. The main reason is, not every employee changes their schedule each week. So using a week number, she would have to go in and update every employee each week. Regardless if their schedules changed, I was hoping to find a way...

Yes I've heard of that, and understand that part. Where I'm having a problem is getting my reports to display the way I need it too. The staff change their schedules often I guess, so one week they work 20 hours, the next 35 and so on. So I created a new table (workhours_tbl) in the...

the tables in question are going to be the tbl_main (this is the attendance table), employeename, and workhours_tbl I don't really have a query or report yet, because I don't know how to format it the way I need. The query I started was percentloss_q but it's just a standard select query...

Here is a copy of the db, if anyone wants to see it.

Thanks for replying I don't think grouping is going to fix the problem I'm running into though, Using my example above In my query I have all 3 tables listed, all linked to the in a 1 to many with the employee table. So since there are 2 work periods listed for Fred (1 with 20 hours and the...

I'm creating a staff calendar type database for a friend of mine, and having some problems with how to create the type of report she needs. Basically because her staff are part time, the number of hours they work during a given week could vary. For example 1 week, they could work 20 hours...

Anyone else have any ideas? There has to be a way when the form loads, to make field B look at the value of field A and update itself to match.

Is there a way to make the second text box refresh on form load and close, to make it update to the first text box? If so, then that would solve my problem I think.

I tried this, but it doesn't solve the problem, when the popup form appears that displays the duplicates. If they change it from there, it's not updating the bound field (2nd text box) on my main form. So the next time the main form opens, it runs the check again and warns them that there...

Hi, I have on my form two text boxes, the first text box is unbound and calculates the values of the ID's from some combo boxes on the form. =[combo1ID] & [combo2id] & [combo3ID] so you end up with a number depending on what the combo is example 123 In the afterupdate of this field, I have...

I don't think you understand what we have. We have a list on our site, that is viewable by all, which is what we want. But there are a couple columns in the list, that we have hidden from those who view with the browser. These fields for each record are filled in by those who have the...

Yes we have security setup on the list, but I have certain fields in my lists that are hidden via the browser. But when using Access the admin people can view and add content to these fields. So I want to be able to secure the frontend so just anybody can't get a copy of the front end and...

Hi, We are using sharepoint as our backend, and using Access (2007) for our front end. In sharepoint I have certain fields in our lists hidden to users who view via the browser. The access front end is for the admins, and more of the fields are viewable using Access. What is a good method...

OK, read up on the common dialog control, and that's an active X control right? I would like to avoid using that, since I've had problems with Active X's in the past. (some users not having it etc.) In the code I used above, am I on the right track? I just want to keep the path to the...

I'm using 2007, but most of the users will be using 2003. I'm not familar with the commong dialog control, I'm just using the technique in that link, I saw it mentioned several times in the forum. Is there a easier method to do it?

Hi, I've been searching the forum on how to create a form that will have a command button, that will allow the user to select a file. AFter selecting the file, I want it to import the file into access. I found this method posted a few times. http://www.mvps.org/access/api/api0001.htm so I...