Search results

Thanks - ill take a look.

Thanks 1 - Noted. 2 - I want the code in one place so that all the forms can use the same basic structure rather then having the entire error coding in every form. 3 - I shall look.

Thanks for replying - I guess my problem is elsewhere... My default form (switchboard) has the following: Public ErrFormName As String I have a public function that has the following code: Public Sub Error() MsgBox ErrFormName End Sub And when the error handler is triggered the code is...

Hello, I'm trying to create a simple function that gives me the current form name. I have a public variable that I want to store the name in before using it in a msgbox. I've looked at some examples but they aren’t clear to me. One in particular was frmName = Me.Name Can anyone please tell...

Yep. The list is of users which I want to default to the windows login.

Hi, Yes they are both text. If i manually type in the value then it shows, but ref'ing to it in the default property returns blank.

Hi all, Please could someone help me with this annoyance. I have a combobox (CBO1) with the below rowsource (allowing me to have an “All” option). SELECT "All" AS [PIC Name], "*" AS [Ref] FROM tbl_REF_Users UNION SELECT tbl_REF_USERS.[PIC Name], tbl_REF_USERS.[PIC Name] AS Ref FROM...

Hello, I'm having a problem with DLookup (I think that’s what I need to be using). In capturing the users windows name in a separate function and storing it as ‘User’. I want then to match the ‘User’ name against a table to return the full name of the person. When I use the below I get...

Hi guys and thanks for your advice. Some of it I understand and some I don’t. I get the point of Ken’s idea but I cant get that to work either. In my public function I have at the moment Option Compare Database Public FileName As String Public FilePath As String Public DestFile As Variant...

Hello, I've been reading up on selecting records in a list box using VBA but so far I can only find details of selecting a record based on counting how many there are. Can anyone tell me how to select a record based on its value. Eg I have txtbox1 which contains ‘=Format(Now(),”WW”) to give me...

In the Private function the Cancel pressed on the FileDialog prompted the code to end and then a msgbox. But with the code split Im not sure how to recognsed the Cancel.

Thanks Ken - How do I recognise that cancel has been pressed?

Hello, I wonder if someone can tell me how to do something in FileDialog? I previously had many private functions using FileDialog, but have now decided to put the basic code in a public function and call it from the private ones. This works fine, but if, when FileDialog is open, the user...

So simple! Thanks for that James :)

Yeah Ive tried that and I get #Error instead of what I expect...

Ah I see - report header is once for the report, and page header appears on each page. I have just one more question for you which I can do on a form but it seems to fail in the repot. I want to format a field in the report (a cut down version of the table). Ive tried variations of...

Thanks again - Just been experimenting with it and have it the way it will let me (and see what I want). Is there a way to have the form header from the first sheet appear at the top of every page? (like header/footer in Word)?

Thanks - Ill see what I can google...

Hello, I've made a report in Access and have a queston about displaying the data. I have for example, data for the past 3 years. I have a header calle YEAR (my firsth header). I want to have the report to page break when a year ends (eg 2008 on one page, 2009 on 1.5 pages, 2010 on one...

Thanks for the details. Ive split to FE/BE yes with master tables in the BE. When I first had this problem I looked through all the options and found Snapshot. when I used it, it solved my "more then 1 person viewing" problem. Perhaps a fluke? I only need multiple people to view it - not edit...