Search results

Hi I have several combo boxes that lookup values such as (1) Null or Is Null and (2) Date ranges, for example, my second combo box has a list of options to select such as: Today Yesterday Last Week Last Month Last Year etc etc How can I use these values to specify the dates in question. In...

Hi Using Access 2003. :( I have a Form, from which I have a "Help" subform (opens using double-click of field) that identifies the field name, the fields caption name and other user specific helpful information on entering data into the field itself. Would anyone know how I would go about...

Hi Could someone point me in the right direction? I've just come across ADT files (Advantage - Sybase). Can access actually read these files and manipulate its data? Thanks Dawn Using Access 2003

Hi All, I have an MS Access table that currently links into word as a mail merge. Great! Sample data as follows: Tutor Student Mr A Donald Duck Mr A Mickey Mouse Mr A Minnie Mouse Mrs B...

Hi I have a query that links three tables together. All with correct joins. The last table contains: Wk1, Wk1Desc, Wk2, Wk2Desc, Wk3, Wk3Desc etc etc My two fields on my form are called WkNo (check box) and WkDesc (Combo Box) and a bound to Wk1 and Wk2Desc respectively by default. On a...

Hi I'm using Access 2003. Sorry, this might sound really basic. I know very little about VBA. I have quite a lot of coding on a Save Button on a form that Calculates Funding. If I want to debug the code to show me each step it takes and what value is is the variables so I can see the end...

Hi I have an SQL statement that ends:- & " WHERE (((???) =-1))" and I'm trying to insert the varible EMAWeek where it is ???. I have this variable in other places of the SQL and works great but it won't work with the brackets. I have an error mesage saying 2001. You cancelled the...

Hi Using Access 2003. I have one PC from about 300 that when I open up the database and click on any Report, they will not open. Any ideas? Many Thanks

Hi, I have created a File DSN using my ODBC under Admin Tools and placed it on the network and have linked my Access 2003 tables to point at this. I have asked a non-domain user to log into this database and open a table but when they do, it defaults to a Domain account until you untick...

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...

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...

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:)

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...

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...