Search results for query: *

I have a table (Tbl_notes) containing amongst other fields RefId NoteID NoteDate NoteType Looks something like this RefID NoteID NoteDate NoteType 1 1 12/01/2005 Response1 1 2 13/01/2005 Response1 1 3 12/01/2005 Response2 2 4 12/01/2005 Response1 2 5 13/01/2005 Response1 2 6...

Hi all, Could some give me some guidance on how to get a dialog box to ask for a location when exporting to excel. Here’s an example of what I’m doing at the moment; eg DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3, “QryTest”, "C:\test.xls", True I’ve had a look at ‘How to use...

Me.DBPathTXT = DLookUp("Database", MSysobjects", "[Flags] = 2097152") This mysteriously appeared on my main menu’s OnOpen event! Can anyone work out what it’s doing? Or event better still any ideas how it might have got there? Bizzar no!

Hi, I have a list box (LstNames) with 6 columns and variable number of rows. I’d want to target the 5th column of the current (selected) row. I’ve read the help file and have spent the best part of the whole day trying various things without much luck. Me.LstNames.column(4,?) Any help or...

Need Urgent help I'm at a customer site as I type this and have run into a problem I can't sort out soany quick solution would be so apprecaited. Problem: when I open a pop-up form on top of another form thats displaying a record in various text boxes the unerlying forms data is lost and the...

I posted this earlier in the 'Citrix solutions' forum but it seems to be either a silly question or beat everyone. Either way I didn’t get any relies. I'm now posting it here in case someone with Citrix knowledge spots it and can help. Hi, I have an Ms.A2k db (front end /back end type) that I...

Hi, I have an Ms.A2k db (front end /back end type) that I normally distribute to run under MS.A runtime. However, recently I’ve been asked to install this on Citrix. There are 30 users of which perhaps at least third will be concurrent. I’ve never worked with citrix except on one occasion...

Hi, I want to use paths stored in a table in rather then pointing to then directly. However I'm having some trouble. The table containing the paths is "TblPaths" and is structured as follows: ReportName DotPath Introduction "C:\Templates\introduction.dot" response...

Hi all, I’m Reposting this from as I think I originally posted in the wrong forum (General database discussion) I work for a firm that has some 500 users of which some 50 use a database that I developed, concurrent usage is somewhere around the 30 mark. Previously we’ve all had full access...

Hi all, I work for a firm that has some 500 users of which some 50 use a database that I developed, concurrent usage is somewhere around the 30 mark. Previously we’ve all had full access rights to the local ‘C’ drive. However, recently a new IT Manager took up post and he’s removed all access...

I’m having a bit of a problem with one of the option settings. I set options from the OnOpen event of a StartUp form and the following work fine. Application.SetOption "Confirm Action Queries", False Application.SetOption "Confirm Record Changes", False Application.SetOption...

I have a number of fields in a report that I export to word as bookmarks. All works well expect for the date field. I've formatted this in my report as dddd d mmm yyyy (say Tuesday 13 Dec 2005). However, when exported to Word it displayed as 13/12/2005. Is this an issue I need to tackle in...

Hi all, I'm distributing a Free app (Fe/Be type) and was wondering how I could restrict the number of concurrent users to say 5. Any ideas would be appreciated. Wishing you all a pleasant and prosperous new year. SmallTime

Hi all, I’ve been given a table of addresses (TblAddress) that has the door number and street name in the same field eg. 123 Howard Way (the field is called address2). I want to move the door numbers to a new field that I’ve created (No) in the same table. Could someone show me a simple way to...

I have a button on a form that tests for records, by running a select query, before opening another form. (See below) Could someone be kind enough and show me how to combine the query into the code behind the button so that I could get rid of Qry_test altogether. Code behind the button: If...

I’m trying to populate a list box ‘List2’ on a form ‘Frm_Alloc’ that’s bound to ‘Tbl_Referral with records that that are dependant on a combo box ‘CmbSite’ on a main menu ‘Frm_MMenu’. If CmbSite is populated then I want the List2 to show the related records that match (Tb_Ref has a matching...

I’m trying to produce a query (probably crosstab) which displays the number of applicants groped by age range and ethnicity. The two relevant fields in table ‘TblApplicant’ are ‘AgeAtApplic’ which is a number data type and ‘Ethnicity’ for which the data type is text. I’d like to ages to be...

I'm having some difficulties distributing an MDE. I think it's a problem with references (Probably Microsoft Data Formatting Object Library). Problem is, because I'm distributing an MDE I can't check. Does anyone know how I get around this? Kind regards to all.

I have a subform ‘FrmForwardAddView’ which contains a field ‘ForwardAddID’. The main form is called ‘FrmLiveApplicantView’. If ForwardAddID is null (no record exists) then I’d like a button on the main form ‘CmdOpenFrmSmallView’ to be visible otherwise it shouldn’t be visible. I’ve tried the...

I've recently come across the following message “Function is not available in expressions in query expression Trim([No]&" "& [Streets])“. Also Date Fields which were previously defaulted to something like Date() now show an error. Something’s obviously gone awry. My initial thoughts were it...