Search results

Hi Ridders (and other contributors) After importing all the data from SQL to Access I ran some tests anf found it to be working just fine. (imagine my puzzled look here.) So i though that the issue must have something to do with the SQL back-end. ... Six hour later (after backup, drop database...

Hi Peskywinnets : While I haven't got my head around 'Visual Studio' yet, I think that it is the product that you are looking for.

@RuralGuy - Thanks, but this didn't make any difference either @Ridders - well spotted, but (sorry to mess you around) . . . the 'Get_Subject' field is a combo box. I was wondering whether the 'faulty' query might have been mis-interpreting the value of column(0) as I hide the column from the...

Hi All I am building a tool that will create academic reports for teachers. The idea is that the teacher assigns a 'generic' comment to each of the grade options in their subject The following are fake comments to illustrate the point. Grade 'A' - Sname was an active participant in the class...

Hi All After much to-ing and fro-ing, I eventually realised that I need to check each form individually. So I had to inspect each form manually and decide whether A. The additional field was required or not AND if so, then B. If there was already code in the BEFORE UPDATE event, then where to...

Hi All. You Are Correct in saying That I Should Not Be Editing A Form By Script. I'm Trying To Add A 'updated By User' Field So We Can Track Where Things Are Going Wrong. I Have Updated All The Tables And Queries, But Now It's Time For The 200+ Forms. I Also Want To Add Code To The 'before...

Hi all The following code creates a label in the BODY of my form. Set ctl = CreateControl(FormName:=strForm, ControlType:=acLabel, Left:=MyWidth, Top:=0, Width:=1440, Height:=288) But I want to add the label in the HEADER section. Any ideas how I do that? PS: While I'm at it, is there a...

thanks Doc Man... Problem is that they might want to use other file formats too (Excel, PDF, JPG, BMP, Audio file, video etc) In the case of 'editable' doc types (Word, Excel etc), it would be more efficient to simply display a NON-Editable version. If they want to edit the doc, then click a...

Hi all - just a little feedback re my 'two steps forwards and one step back" I have been testing "the doc man's" ideas - most seem to work well for what what I want to achieve. IE docName field Locked = Yes (The user MUST double-click on it to either add a document OR open an existing file)...

Thanks for both of your replies. I guess this is a bit like asking the TV station to tell you which shopping store is the cheapest. While option 1 seems to be the 'no brainer', Doc Man - I like your thinking here. Question : Supposing that I did make a backup copy before presenting the doc...

Hi there Looking for a bit of info (Pro's/Con's) regarding the use of a MEMO field vs linking to a doc. As a school, we often need to manage either a students health, behaviour or learning ETC.(or a combination of these.) Some requirements * This involves developing a plan to manage the issue...

Ahh - sorry all It turns out that the data in the new (updated) recordsource query did not include the date field. DUH!

Thanks Gizmo. The first suggestion worked a treat

Hi All If I look at ALL my records (IE: the forms recordsource as per the underlying query) then the date is displayed correctly. However, If I want to filter records (by changing the recordsource as I cannot use a filter in this case.) then the date displays as #Name? The field is a datetime...

Hi all I have a few forms that call a function in a module. The call is changeaddr(me.form.name) However in the module I want test conditions and then (if required) change values on the form that made the call. In short, the function looks like: Function ChangeAddr(FN as String) If Not...

Thanks Minty If I understand you correctly, then what you are proposing is that I create a main form with a sub-form. The main form displays : 1. A single record from a query and 2. Is linked to the subform. (IE. as a record is selected on the subform, the corresponding record is displayed for...

To the access gurus our there. In this case, does it matter what language the PC is set to?

Hi all I am using a split form to find and edit existing records. On the form I have set the following properties. Split for Datasheet = Read Only Allow Addition = NO Allow Deletion = NO Allow Edits = YES Allow Filter = YES Order By = [BLANK] So long as I use the form in this 'default' format...

Hmmm...interesting. Thanks PBaldy. I will 'suss' out SSIS

Thanks for your input. I use SSMS to create and maintain tables on the BE, but have no idea how to build a FE solution with either SSMS or Visual Studio. Hence ....Access. Am I right to assume that you're saying (for you) it's more about improving response time (whether the problem is related...