Search results

Hi, If I have a time like 22:00 and I want to add lets say 300 minutes to it; so it now shows 03:00 how do I do this? I can do it in Excel alright with the TIME function but cannot find a similar feature in Access Liam

Hi guys, I'm just looking for some general views and opinions here and would love to know what people think; advantages/ disadvantages etc. We have a system of spreadsheets traking various ongoing projects in our organisation which are sitting on 6 different regional servers. This poses a...

Hi, This is probably going to be a quick one for somebody, I had a search through old posts and couldn't find anything. I have an Access form and using a button on the form I start an instance of excel. I then have: oExcel.Visible However after I open Excel and make it visible I want to...

Hi, This is probably going to be a quick one for somebody, I had a search through old posts and couldn't find anything. I have an Access form and using a button on the form I start an instance of excel. I then have: oExcel.Visible However after I open Excel and make it visible I want to...

When I open my report it keeps asking for the parameter value "intJobIDPK" even though it is contained nowhere on the report of in the query for the report. It makes no difference what value is typed in for this, the report displays the same. How can I find what is causing this or how can I...

Hi, I need to print off an ID card for every record in my database, but the pictures won't change when I go through the records. I am setting the picture using the "Report_Activate()" function, which is obviously just setting the first picture for every record. Is there a function that will...

Lads, Here's a little problem that is driving me nuts. I know what is wrong and yet I can't fix it! I have an Access D/B and a mail merge word doc which gets its data from a table in the database. Now the date is in the correct format in the table i.e. uk/european format. The 5 of january 2005...

Hello, I have a query that returns a list of courses undertaken by certain employees. They are in the format NPTC CS 30; NPTC CS 31; NPTC 33; NPTC FTC 38; NPTC FTC 40 etc... Anyway what I need to do with this is convert these results to a string and manipulate them in such a way that they can...

Hi, This should be a really quick one for you guys... I read somewhere that Access catches carriage returns in a text field so that even for addresses that will contain more than one line, I can still catch them in a single field and they will display as multi-line values. However when...

I have a form which contains a date field. After the user has entered the relevant information on the form I use some sql to run an append query to write some of these fields to another table. One of these is this date field. However, inputting the date on this form is not mandatory so...

Hi, I dunno has anyone come across this problem before - maybe I'm dreaming! I have noticed this happening in quite a few db's I've developed and used to pass it off as some quirky glitch. I have been copying and pasting code from one form and using it in a second form. However it doesn't seem...

Hi, I have a form with a button which allows the user to save the record using DoCmd.RunCommand acCmdSaveRecord This will generate a standard Access error (run-time error 3314) message if the user tries to save the record with required fields missing. I wanted to pick this up in the Forms...

Hi, I have a form and if the user makes changes to a record I use the BeforeUpdate event of the form to ensure they wish to save these changes before moving to a new record. Private Sub Form_BeforeUpdate(Cancel As Integer) If MsgBox("Data in the current record has been changed since the...

Hi, Unfortunately my patience with MS Access is wearing thinner and thinner by the day now. I tried to do a very simple thing this morning. I have a form which previews a report - fine. Now if the user decides to print this report I want that to trigger the printing of another report also...

Hi, I have a db with the tables linked between a BE and FE. It resides in a folder on the server \\server001\RBRS\ and I want the users to be able to copy the FE down onto their own desktop with the shared BE residing on the server. When users copy the FE onto their desktops do they need to...

Hi, Using Access 97 everytime I export/pulish a report with Excel I get the same "invalid sheet name" error. It still opens the report in Excel but how do I get rid of this error? Thanks, Liam

Hi, Im using Access 97 and I was just putting the finishing touches on a small db when the user made some minor changes to some of the information being captured. No fields changed but some of their properties were altered, I put in new input masks in some cases, changed the field size slightly...

Hi, We've only recently switched our systems over from Office 97 to XP; now the VB in the back of lots of my databases doesn't seem to work anymore. This code now produces all sorts of errors: (the vars sqlSearch and qryName are two string set in other mods) ' @var dbs a database object Dim...

Hi, I'm having a bit of trouble getting my head around the user level security in MS Access 97. It seems to me that when I set up user-level security it is set up for MS Access as a whole rather than for a particular individual db. I do not want to have to log in every time I open Access or...

Hi, Just a few general queries I was wondering about. I've heard various rumours that Access is not "safe" to use in a network enviornment. I had intended using a split Access DB with an FE on each users machine and a BE residing on out local server here. However our IT department refuse to...