Search results

Is It Possible That In The ONE Case, There Is either A Typing error The Category List or There is no product for the category in question

So are you saying User Clicks A Category And Selects "widgets" When User Clicks On The Product, Then U Want Them To ONLY Choose A Type Of Widget If So, Then I Suspect That in the on change event of the CATEGORY combo box, You Need To Requery The Product Combo. Something Like ...

You probably need to have a hidden field to keep the temp start time. Also Make Field For Duration. When start is clicked, both the real start and temp start fields are set to the start time. Then, in the pause buttons on click even, say something like Duration = duration + (Now...

Hi Midnight Sun Are you able to rephrase your question. Im not able to follow what ur trying to do.

Hi BettyWho I am thinking along another line. I assume that you know who the acting principal will be? What table does that informatikn reside in? How about a few update queries that run in the forms 'on load' event? Qry1 . Sets the acting value to null if the current date > Date () Qry2. Update...

Problem Solved. I figures out a way to do this, but thenrealised that it created other issues for me later. So i have had to abandon this plan anyhow.

Hi On my 'on load' event of my Navigation form, I get the Logged-In-User-ID and assign that to a hidden label (Label62). I then have a query (Qry_LoggedInUser) that filters the user info according Label62.caption. I am writing an 'after update' event on a field called PO_Num, that will look...

Thanks Spike. Initially, the DB will be accessible to all users when they are at home base. As we estable VPN's fromn the remote sites, they will be able to access from 'far, far away'. As for speed issues, I am thinking that seperate DB's might split the proceessing on the server, thus...

Hi there I would like some advice, but first I need to give you quite a bit of info, so here goes. I work for NGO of +-200 users, which (as usual) has ZERO spare cash to invest in a fully fledged Sharepoint / SQL based solution. Consequently, I am looking to develop a pilot solution in ACCESS...

9 Times Out Of 10, I Need To Type My Submission In Notepad B4 I Post. This Is Because My Session Times Out B4 Im Done. Can U Increase The Sesion Time?

Thanks Lagbolt Hmmm - After posting, I was wondering if I couldn't solve problem 2 as follows. And would this be the same as working with recordsets? Instead of 3 forms, limit to 2 forms - Namely, StockItems (Parent) and Orders (Subform) On the Parent Form, create a hidden field (called...

Hi there I would like my users to be able to view stock items in one (sub)form and when they double click on an item, then certain data is copied to an orders (sub)form. I have therefore embedded two unbound subforms into a master form. The master form (Frm Stock) has no fields, but it has 2...

Not as much work as you think. 1. Get the SELECT query working properly. 2. Click the "MAKE Table" icon - it will ask you what u want to name the table. Call it "TEMP" - When you run it, this will simply take a copy of the records that match the criteria of your select and put them into a new...

Hi Glen Have you tried to change the FORMAT that the Yes/No box displays.

When I run into this sort of issue, I generally try a two-step approach. I would make turn the SELECT into a MAKE Table query. Then I would run the update query based on the table that I have just made. Remember to delete the temporary table afterwards.

This usually indicates that query is pointing to the invoice DETAIL, rather than to the invoice HEADER record. Check that the query is looking at the correct source.

HI folks I have a table where student attendance history is recorded. In order to update a student attendance for today, I would like to select their latest record (from yesterday or Friday if today happens to be a Monday) and assign the same attendance status that they had the last time that...

If I rewrite your condition in the form of IF something then Do this ELSE Do this Then your statement says IIf( IsNull([Reply Date]), THEN DateDiff("d",[Due Date], Now()) ELSE )

Hi there I have found that the Northwind DB is a GREAT tool for learning how to develop an app in access. Unfortunately, I have not been able to figure out how the NW DB should be used in Office 2010. EG - How does a user order stock? The "Purchase Order Details" form is used to order stock...

Hi HGUS393 Thank you for your quick response. I only managed to try using the code earlier today. Initially, I had a problem when the code got to the second record, but after a restart (of the PC) - it seems like its been resolved. Thanks a ton. Once again, I have learned a very valuable...