Search results

I have a report which formats a value for me but its not doing quiet what I need it to. This is its control source: =format$([tblColumn],'ww',0,0) Which return for eg. 41 I need to return the Mondays and Fridays date of week 41. Is there another way I can change the weeks to work...

HI I have this bit of code Private Sub Report_Open(Cancel As Integer) Me.imgLogo.Report.Picture = gblIMAGEPath & "logo3.gif" I get run-time 2455 you enters an expression that has an invalid reference to the property Form/report. Any ideas?

Can someone please help me with trying to understand the pros and cons of using global variables. I know they can be used anywhere within the db but I assume that they consume memory.

Hi I have a column in a table that is surpose to be a numeric value. Now in my form when a user types in an incorrect value eg. "abc" and leaves the field they get a very un-user friendly error message "The value you entered isn't valid for this field. For example, you may have entered text...

HI I have a fe/be setup is there any code/function I could use to backup the be. Each of my users have their own front-end. Would the code need to kick users out of the BE to back. I would like to save it to a specific folder and needs to be run within my DB.

Is there a way of finding out what objected called this update function (Form_BeforeUpdate(Cancel As Integer)). Like navigation button or a "save" button on the form. I have some validations that I want to run when the user saves but it must not run when the user trys to exit the form i.e...

Hi, I have an autoexec function which runs but I want it to pause and bring up a login form and if the login is successfully then continue with the rest of the autoexec. How can I make autoexec function wait for a response from a form before continuing?

Hi, I'm trying to get this to work but before I run it I think I've confused myself but just double checking When you open the updated You have to browse three this. 1. The first browse is that the fe the user would normally use or is it the master. 2. Simply the BE and its location. 3. Is...

Hi, Is there anyway I can change my grouping on a specific field either by changing the field or changing the criteria eg a date field group by day/week/month/year I have to date fields that I would like to use. If I can do this with code what is the best event to use to trigger this. Or...

Hi whats the difference between class and module. I've done loads of vba coding in Excel and recently access but I've never got my head around these two so I tend to put all my code into modules. Could someone explain it in laymans terms. Many Thanks

Hi, Any tips on how to make code fail gracefull and report back the error to the end use? I've done a bit of vba coding and would like to better my coding skills which I think one of my weaknesses is capturing errors and making it fail gracefully.

Hi, I want to check my values before they update a record. this is the private sub on the form Private Sub Form_BeforeUpdate(Cancel As Integer) 'On Error GoTo err_validations Dim l_check As Boolean l_check = validate_SO_record(Me.database_id, Me.data_for) 'If (l_che = False)...

Hi In one of my fields in my report I have the the control source set as follows: =IIf(Forms!frm_standing_order_report!Option16.OptionValue=1,[bank_statement_date],[data_for]) Its returns #Error. I have an optiongroup that has radio buttons this is placed on a tab within one of my forms. If...

Hi, I have a form that has a radio button on. What I want to do is change the data source for a particular column of my report based on the radio buttons value. eg. radio button has two option "show col1" or "show col3" my report is as follows Col1 | col2 If the user has selected "show...

Hi, I have a form with tabs and each tab contains a subform. How can I set this subform to start with a new record?

Hi My report is working perfectly except when it start getting to the bottom of the page the group header seems to print the header and then the data onto the next page which is a bit point as I would like the header to be on the same page as the data. Any idea how I can sort this on out?

Hi, I have a column report i.e in my detail section I have Col1 | Col2 | Col3 Comments: Comments value I've report is perfect and I have now added the comments into the report but it not giving me the results I was hoping for. I wanted to only expand the details section and show the...

Hi I've been asked to develop an access database that multiple users will have access to. It will sit on a shared network. There will at the extreme most be 20 users. Where should I start? I've heard of splitting the database and let the user have a local front-end though I dont quiet...

Hi, As I'm new to this forum I will briefly describe my experience, I have extensive Excel and Excel VBA knowledge and have been working with ORACLE products for the past 3 years. I need some help with a combo box (It maybe a design fault from my part) but here goes I got two tables...