Search results

I've a field and in each row the data is AB1234, ABC1234, AB235, etc. I want to extract just the letters at the beginning. Usually there are either 2 or 3 letters before you hit the numbers. Is it possible to do this. I was thinking along the lines of trying to find the first number and...

I've converted a 2002 database to 97 but when I launch the 97 version I get the message "can't assign to array" and takes me to the code. I also converted it to 2000 and it works okay so there's something I need to do with 97 version. Anyone point me in the right direction. Thanks in advance.

I've been asked to create a database to look after our licensing issues to control who has what software on their machine. A nice project I thought but my problem is the current data is a complete mess in that there has been no control over people sharing/putting software on their machines. For...

I've a query using the Totals feature which is counting the number of licences issued (column 2)to the actual number of licences available (column3) SName CountofSname NoLic Photoshop 6 5 Word 5...

Some general advice needed here. I've a list of laboratories who deal with Analytes(eg, ore, zinc, iron). There could be 200 plus of these. The labs also deal with Matrix(eg, fish, herbs, shellfish). The way I set it up was: tblLabs LabID(PK) LabName tblAnalytes AnalyteID (PK LookUp)...

Had to admit defeat I'm afraid. I got the following code to work to produce a dynamic query using 3 multiselect list boxes. Works fine. The 3 listboxes are lstConsulation1, lstStakeholder1 and lstCountry1. However, it only works if I make a selection from all 3 lists. If I leave one out I get a...

I found that I can place a symbol (an arrow for example) in a label by changing the properties font to wingdings and putting in the appropriate letter in the caption space. An e with an accent will give an up arrow. My question is how can I find out which keyboard character tallies up with a...

Did a search but couldn't find quite the answer. I've a very long list box which I'm using to perform a search. To help the user I thought it would be an idea for them to be able to select record(s) from one list box and move them to another and then perform the search from that list box. Any...

Very basic question this (and quite possibly a stupid one). When you have an option group is it usual to have that stored as a Number data type or is it okay to leave it as text type? I ask because on some databases I've seen it's stored as text but I'm thinking that it really ought to be stored...

I'm pulling out logs over 30 days old using <date()-30. The user wants the 30 to be working days. Any ideas how to go about this. I've looked at Mile's thread below but cant quite see how to incorporate it into my needs. Am I on the right track...

I'm running an append query from a form. Works fine. Once I've run it how can I get it to go to the record that I've run it from. It keeps defaulting to the first record?

I'm running a report from a form and have a text box which the user types in a word. At the moment I've the following code: DoCmd.OpenReport "Staff Details", acViewPreview, , "[Last name] = '" & [Text4] & "'" This works fine but instead of entering a full word in Text4 I want to insert a Like...

Did a search on a thread for this and came up with making the form pop up and modal and works fine particularly as the code option was too complicated. Just one thing, am I right that this also hides the taskbar at the bottom of the screen or have I done something wrong? Not a major problem as...

I'm using this code to pick out items on a list box and create a query. I've only put this bit of code because I think this is where the problem is (hopefully) For Each varItem In Me.List0.ItemsSelected sPerson = sPerson & Me.List0.ItemData(varItem) Next varItem sPerson = " [ID]...

Sorry, spent all morning on this but without success. I've a custom report toolbar which I've amended by putting on the CTRL + P icon. This is fine and when I open the db in shift enter the toolbar is fine but whenever I open the database and run the reports the toolbar hasn't picked up on the...

A user had 30 questions all yes/no/don't know and a pop up box to add comments to each question. I had organised it that the user ran an append query which put all the questions into a sub form. Nice. Unfortunately, she now wants to restructure the whole thing and I've no idea how to tackle it...

On a form I've a button to open another form. The new form shows the relevant Participant's records. Dim stLinkCriteria As String stLinkCriteria = "ParticipantID=" & Me.Particpantid DoCmd.OpenForm "tblComments", , , stLinkCriteria What I want to do is add another criteria to filter it out...

I have a listbox detailing countries that I use to run a query depending on which countries are selected. The list has become very long so the user wants to filter out the EEC ones and non EEC ones. I thought the best way would be to add a column for EEC to the underlying countries table and...

I've a form with 2 buttons. One to add an entry, the other to edit. They both access the same form. This form has buttons on it that I want to be invisible if you're adding and visible if you're editing. I know I could have 2 separate forms but was wondering how to do this with just one form.

I'm using the following code found on this site for emailing from Access to Lotus Notes. Works a treat but I've found that if the total number of characters in the email addresses number over about 270 then it doesn't work. The addresses dont transfer. Any ideas why this is? Dim intCounter As...