Search results

Hi! Basicall I neet to put a good bit of text on a button. I want to put it on two different lines but when I press return it exits text edit. I tried putting text labels on the buttons, but when the button is pressed, these labels fall behind the button and can't be seen. When I just keep...

Code Hi, This is the code that I'm using; Sheets("Input").Select Range("F4").Select If Selection = "D" & "*" Then Sheets("Units").Select Range("B2").Select Selection = "DCP1" ElseIf Selection =...

Thanks that static thing worked :) Another Excel VB question coming, sorry! Basically I have to check if the first letter in a cell is either D of G, and then perform an action. But I've tried this and it doesn't work: If Selection = "D" & "*" Then Do something ElseIf Selection = "G"...

Hi. More of an Excel question, but someone might be able to help?? Basically I have a column of cells whose value is determined by the formula =B2 & C3 & C3 and the next cell - =B2 & C4 & C4 and then =B2 & C5 & C5 and so on. So that the first part always stays the same, and the last two...

Copied Hi, Basically I have to send the records in the query into an Excel worksheet so calculations can be performed on the data. The Formulaes are on sheet 2 and the query data is on sheet 1. I tried to link the query and the worksheet, but that doesn't work; anytime I update the query the...

Hi. Basically I have to write a macro that opens a specific query and then copies all the records onto the clip board. It's the only way of doing it. Does anyone have an idea of what the code would be like. E.g. Opening a query in VBA etc.. Thanks, D

Hi ya, Basically, I have a variable that I want to use in two different Subs. I declare them as being public i.e. Public month As Integer ...but I get an error saying; "Invalid attribute in Sub or function" What can I do??? D

Thats working grand. Thanks alot, D

Sorry, I probably didn't explain properly. I don't want to add a random number to the file names. The new files that are sent to our company will have a random number attached to them [as far as we're concerned]. What I need to do is for VB to loop through all the files in the folder...

Hi! Basically I have to import a number of files from a directory in the C: drive. All of the files have a standard form, for which I've written code to loop through the folder. But now the files will be having a five digit random number added onto the end of their names. I've tried writing...

Hi!! Not strictly Access, but maybe someone can help. Basically I want some VB code to import the contents of a folder. The folder will contain about 30 files. Is there anyway to just say - import all of the files in this folder one after another - without acyually knowing their name>>>>...

Wahoo Cool, it's working now, thats all for your help, Much obliged :) :) D

Problem The problem is that when I put the line =Forms!frmSelectCity!cboCity into the creteria row it comes up as a text box with "Forms!frmSelectCity!cboCity ", in which I have enter some criteria, instead of opening up my combo box???? Whats happening?? Thanks, D

Still When I put =Forms!frmSelectCity!cboCity into the field section of the query it turns to Expr1:Forms!frmSelectCity!cboCity, and still doesn't bring up the required combo box. When I put it into the criteria secton it still doesn't work!! Is there any other way of bringing up a combo...

Combo Box thing Hi. Yea, I tried that, but it doesn't work. When I typ ein the command =Forms!frmSelectCity!cboCity into the Query criteria section, it puts them into [ ]. What can I do????

Loosing focus Hi again. Ok, so I did what you guys said and it works fine. But the only problem is that when the form opens the "Details" part is "active". Is there anyway of having the "Details" part "greyed-out" or inactive by default when the form is first opened???? Thanks for you help...

Hi all! This is my boggle: Basically I have a form that take in a bunch of data into a table, grand. There is a tick box on the form. The user ticks the tick box is there is no information to be entered in the "Details"part. I want the form to kind-of gray out the "Details" part of the form...

Hi. I have this query that is used to generate a report. But there are five different locations like say "London" and "Paris". I want to create a parameter query that promps the user for the location, and only displays the records in that particular location. I can do that part grand in the...

Thnaks Thanks, I'll give it a try :-)

Hi. Can anyone help me?? :-o Basically I've got to generate a report based on a bunch of records in a table that all have dates associated with them. Grand. But the problem is I've got to show only record between two values entered in a form: begin date and end date. Is there any way to do this...