Search results

Hi Using Access 2003. How do I specify how many records I can print on one page? I want to print on a pre-printed form and I have only room for 24 rows. Many Thanks.

Hi there folks! Any assistance would be greatly appreciated. I'm not sure which version(s) of crystal I require. I want 5 (maybe concurrent) users to be able to develop / write reports. I want the end user (site-wide College Users) to be able to access these reports. In the future, I am...

I would be grateful if someone would take the time to read, give any useful advice, recommend any WM based training companies or point me in a starting direction, my head is ready to blow. I have self-taught myself MS Access for 7 years now (bad I know) and from this have created several simple...

I've done this and it now says Sub or Function now defined. Again, thanks.

Thanks for this, How do I place this code after here. Private Sub OKButton_Click() Also am I right in thinking that the following lines would be changed:- arrTables = Array("tblmyFirstTable", _ "tblmySecondTable", _ "tblmyThirdTable")...

Hi I don't want to delete the table first. Thanks for the code but I alsso don't want the user to specify the location. it will be one of two locations which will also be static. Thanks

Hi All I've read all the posts on Linking tables and found no solution to my problem. Would be grateful if someone could help. I have a FE database linked to many BE databases. I'm concerned with only 2 tables in one of my BEs. tblCourses tblStudents each table contains data within for an...

Hi there I have a form which hold its data in form of a query which the user manipulates. In the form there is a calculate button that runs through a series of steps, one is a sql command as below: UPDATE tblcurriculum0203 LEFT JOIN tblDLNBR ON tblcurriculum0203.acad_period =...

A2K I have a form set to continuous forms. I have only one record/line displayed and can scroll up and down etc etc. I've tried designed the forms so I can see multiple rows but everything I seem to do doesn't work. I know its something to do with the form properties becuase I fluked it last...

I know there are many posts on this but still cannot find what I want .... I have a string .... ... <surname>bloggs</surname> <fornames>Jane</fornames> etc.etc. ... <surname>williams</surname> <forenames>Jo</fornames> etc.etc. In a query I know how to: Find the Start and End Postions as...

Thank you, this works.:D

Hiya Using Access 2003. Can anyone tell me why when I hover over the variable/field name in VBA I can no longer see the values?? I have put in breakpoint and they do stop but just don't show any values. Thanks:)

This is overcome by selecting Tools, Macro, Security, Low and clicking OK.

Hiya Have just created an access 2000 database which when a user logs on to the network as herself and tries to lookup any combo boxes or click a button to run a query from a form it shows or does nothing, yet when I log on I can. Our IT Services have looked at folder/share permissions which...

:mad: I have created an Access 2000 database sometime ago now that is split and has mutiple users. Which has worked perfectly fine. I have since made some design changes. I now have *most* of my staff saying that (mainly on reports) when they try to perform an action the standard Microsoft...

I don't want to do this. I have other checks also.

Access 2000. I have a data entry form that before the user selects another record (via a combo box) or the user clicks the save button I would like to be able to populate another table. Basic e.g. If the user leaves one or more mandatory fields blank on the form I want to update / append...

I've searched through the forums to no avail. I have two seperate fields representing start and end week numbers. (Access 2000) e.g. Field 1, Field 2 1, 12 1, 43 13, 30 30, 53 Can I have an IIF statement that can tell whether e.g. wk 13 is between these two values, if yes then 1 else 0...

Sorry, this doesn't work either.

If I sum totals I receive a 2 in week 3 I only want 1 thus the need to merge not sum. Thanks anyway.