Search results

Hi - I've searched the forum but couldn't find anything on this. We are moving from LAN servers to a shared cloud across a WAN, with optimisers installed that apparently should give the end users a very similar experience to what they get today - I have no doubt they will for other...

Hope someone can shed some light on this one. I have just converted the backend of a secured 97 database to 2003, it was secured using an mda. Now that its in 2003 I have tinkered about with permissions so that I am able to rerun the User Level Security Wizard to create a new mdw file for my...

:confused:I have a very strange problem... I have some normal select queries created that build up into one query. The final query is a cross tab. The purpose of this final query is to show all the information for one record and have the STATUS TYPES as column headings the DATE of the STATUS...

Good morning - hoping someone can shed some light on this one. This is an Access 2003 database... I have several queries that build up into one which I have then used to create a Crosstab Query. All the sub queries run fine. But when I combine these with a crosstab I get the error 'The...

I have an Access 97 backend and Access 2003 mde client. One of the forms in this is database uses fields bound to a query to show the dates of a certain record and unbound fields to allow the user to suggest new dates. The on click event of the save button uses SQL to save all this...

Can anyone help... I am writing a query in which, amongst other things, I also want to perform a dateadd calculation. I have the following expr:dateadd("d", [lastduration], [lastlandingslot]) This fails to run as the expression is too complicated, I suspect this is because a lot of the...

Hiya, Not sure if this is possible via a query. I have a table containing RAG information for studies, and I simply want to retrieve not the last record for each study, but the one before last. One of my customers would like a report (athough big report so will just be a query exported to...

Hi, I have some VB on a form and part of its job is to display a message if certain criteria is met, the code itself runs but doesn't appear to be calculating correctly....I have highlighted in red the section that is being missed, because the app is calculating the result as false If...

Hope someone out there can help. I have a form (frmNewExceptionRepot) where the record source is a table (tblExceptionReport) there are a fair few controls on the form from this table and some controls that are based on queries etc I have a cmd button - that takes the value of text boxes from a...

What to do something that I initally thought would be easy to find out..no such luck! The code is below and works fine, however I only want the first If to run if the start of the fesibility_code is "0" AND the second digit is not a numeric one. i.e. Run only if the code is 0AB or 0BB etc...

:confused: Hi all - hope someone can help I dont know where to start. I've got a cmd button that imports data from a excel sheet - that actual code is working fine, however when it runs it causes Access to freeze. The data in imported correctly - so it must complete the process but Access...

Hi - Hope someone can help - I'm stuck! I have an inherited database thats about 10 years old written in Access 97. There is a cmd button that is importing data from an excel sheet into a table. One of the fields [TBCS Code] being imported is a two digit number - always starting with 0. The...

I have db running on Access 97 with a backend and client front end. Mainly running on NT platforms. This database also uses an .mda file for security. The past couple of weeks this security.mda file has become corrupt and locked. This is preventing people from accessing the database. The...

Please help! Working on an Access 97 database that I have inherited, on win 2000. The database is converted into an .mde file for the users. I need to convert my new version to an .mde file, it does convert, but then when trying to open it afterwards gives the error below. Believe it's...

Hi (again!) Wondering if anyone could shed some light on the following I'm confused (again!) The code below is on the onclick event for a button on a form in Access 97, its purpose is to prevent readonly users from updating the field. It does this fine, however I need to change it so it will...

Hope someone can help - not got loads of experience with VB - It an enherited database running on Access 97, my ws is running on Win2000. I have the following code on an onclick event of a cmd button. Its basic function is to take the number that has been entered onto the form (always a 4 digit...

I have got a form that updates a sql database table 'Problem'. One of the combo boxes on the form is called product name which is based on the contents of a view from sql (the view is the table 'products' sorted). Once a choice is made from the combo (on change) the record is saved using...

Hope someone can help I have a database that records different types of Hardware Calls made. There are reports based on crosstab queries. I have a form that the user can specify the dates to run the report from, before or between. The code I have used to do this is below. This works fine...

I am trying to password protect a form (SASMenu), but have come across what seems a common problem.The text the user types is displayed instead of having an input mask of ******** I have looked but have found no way on formating the inputbox. From a thread I found I have created a new form...

I need help in specifying what the NO does in a message box. I have a form which adds a record to a table, on this form is the button to save the record. However I would like the users to be prompted to select YES or NO to confirm if they would like to save the record. If they select yes then...