Search results for query: *

We have a large Access database which is a bit too slow for the growing number of users and records it now holds, so we have finally got agreement to upgrade to SQL server for the backend. My question is what is considered the best thing to use for the front end - can we continue using the...

Hi, could someone save me from pulling my last few grey hairs out please - sure I am missing the obvious. i am using a series of combos to filter down records, and for the most part it works fine - snippet below does for example: ' If Project Name If Not IsNull(Me.cboProjName) Then...

Hi, I;ve been asked to pull together at very short notice a database to track contracts on a short-term basis - up to 12 months. So quick and dirty will be fine for this if necessay! Apart from the obvious details like supplier details, there will be a number of fields that users can update as...

Hi, been a while since I've dabbled with Access and missing something very silly! I have this code: If rst1![Request_Type] = "New" Then 'New request, check for ID's with these SRNs or Names i = rst1![No_Users] For c = 1 To i str = rst1!("SRN" & c) The...

Hi all, missing something simple I think but can't work out what! I have a number of chechboxes on an Excel sheet and need to make them visible or not depending on other parameters. The following works of course: If tp = "Y" Then 'make all checkboxes invisible Me.CON1.Visible =...

I have an automated Excel form our users complete to amend system access. It contains a fair bit of code, enables users to make a number of choices including the manager who should approve the request, then when they hit submit it mails the workbook to that manager. It works perfectly from my PC...

I usually work with Access but have been asked to sort out someone elses Excel project. When running several of the code blocks the screen flickers annoyingly as it updates. In Access I would hide this using the Echo command, however this is not recognised in Excel. Is there an equivilant I can...

Hi, sure it's a silly question, I know I've done this before but can't see wood for trees. I need to reference several field names in a recordset in turn, in a loop. I have the recordset, and using the field name directly works e.g. str = rst![FieldA] However, if I try and capture the name of...

I have an Access Database which monitors an Outlook inbox and performs certain automated functions for incoming mails meeting certain criteria- generating reference number, mailing response etc. I'd like to take this a stage further if possible. Relevant incoming messages will have an Excel file...

Hi there I have an Access database with a module which monitors an Outlook Mailbox for incoming messages. When it finds suitable ones it adds a ref no to the title and returns an email to the sender to advise of the reference etc, and then moves the mail to a specified folder. This all work...

I have written a database which produces a list of staff, split by Manager, showing system access rights for regular review. The database creates these as Excel spreadsheets with the managers name in the title for ease of mailing (canlt automate mailing at present due to using Lotus Notes, worse...

Unnusual issue I have here. Have a databases containing user system access records- currently around 6k records, been working fine for a year. Has a search form where you can search on many criteria including users ID. Issue is if I search on user ID BCAK, on running the code Access changes this...

Hi I am populating an array using the code below, which works fine and I can see the correct contents in the array in the locals window. The code is called from the forms on-load event. However, I then need to reference this array on the click of a button and compare an element of it to the...

Hi folks, a general question to call upon your many years of experience if I may. I am bout to start work on two farily large projects. There are distinct elements of stuff I have done before in both, so i am tempted to start with a copy of a previous successful project and modify. However, I...

Hi there I am using the code below to create snapshot images of certain Access reports as it seems to be the only way to email them without loss of formatting. In fact it works pretty well. Public Function Snapshot(strReport As String) '****Creates a Snapshot view of the chosen report...

Hello I want to write a function that can be called from a customised menu button on an open report, which uses 'OutputTo' to create a snapshot of the report for emailing. I can do this for a single report with the output name hardcoded. However, how can I use this function to work with...

Hi I have implemented the ActiveX progress bar available from the Access toolbox under 'more tools'. It uses simple code to monitor progress through a recordset and update the bar on each loop. This is shown on a form and monitors progress updating values in a table. However, I would now like...

Hi Probably a stupid question, but can Access store symbols in a table? I have a project database and would like to use symbols to show project status ie smiley face if on track, sad of not etc. Can this be done? Thanks Nigel Didn't someone say work is supposed to be fun? They didn't have...

Hi I am fairly new to VBA and in at the deep end. I have come up with the code below, which does what I want accurately. However, the issue is time. On my standalone development machine, split FE and BE, it runs in around 5 seconds, which is quite acceptable. When I run it on the network, this...

Hello all I am doing some work on a database coded by someone else. I have come across this unnusual way (to me) of using errors: A form is opened using a filter to restrict the records. In the on-current event of this form, there is code that checks and inserts a value in a text box. Fine so...