Search results

Hello All Hopefully someone can help me here. I have been given a .sql file which I want to upload into an access database. When I open the file this is the heading in notepad (which I hope helps) SQLyog Community Edition- MySQL GUI v6.05 Host - 5.0.37-community-nt : Database -...

I am trying to filter a form on two things using the properties pop up box within the form design. Initially I had it as just filtering on one thing and it worked fine [InboxMerged]![Valid]=True However I want to filter on two things now, the above and a date time stamp as below...

Hello All, hopefully someone can help me with this I am building a response database, where someone in the orginisation can ask a question in a text box (memo) and another will answer it in another text box on the same form. However, there is a slight issue that if the user needs to scroll...

Ta for that Just one more bit How would you tell access to look at another text box at the same time to get min AND max parameters WHERE tblSchool_Clean.TOTAL_RESIDENTS > Forms!YourFormNameHere!txtResidents1 & _ AND tblSchool_Clean.TOTAL_RESIDENTS < Forms!YourFormNameHere!txtResidents2 ...

hello all I have a form, which has a number of multiselect list boxes on it. I have managed to work through the code to create an SQL string so that it queries a table based on these selections (something that I am very proud of) The basic jist of that code is If...

I had a similar problem recently and this solved all my problems http://www.fontstuff.com/access/acctut11.htm

yeah, but it is very crude :) having a 100 line drop down list, but I think that this is the only way to go :( Ta for the reply

Is it possible to have a spinner button on an access form, similar to what is in Excel? I want the user to be able to select a percentage value and then have access limit the results brought back based on this selection, and would prefer it to be automated rather that have the user type in the...

Good Afternoon Everyone I am trying to get a list box on a form to show the name of the reports within the database, and after several days trolling forums I came across the msysobjects approach. I am typing the following in word for word in the ROW SOURCE of an unbound list box on the form...

Hello All I have a form based on a table which is currently sorting itself by an alphanumeric text field called "Query_Code". The sorting order is currently in ascending order, thus it sorts empty data points then by the "Query_Code" eg [Empty] [Empty] [Empty] [Empty] QU000001 QU000002...

Hello All these last two weeks I have gone on a self taught VBA coding journey, and suprisingly it has gone quite well. However, just to finish off what I am working on I have one small issue that I am sure someone can help me with I have some code, which works fine but when it has all...

Bob You are a star, if I wasn't on a completely different continent I would buy you a beer. All I can do is add to that repuation thing. Ta Loads Mav

Ta for the reply but for some reason this didnt work :( When I go into the form it allows the user to move through the records and leaves the field blank In the Design View of the table I have the following selected Required=Yes Allow Zero Length=No Indexed=Yes(No Duplicates) Ta Mav

Hello I have been asked to make sure that a "Query Code" is inputted onto a form that only one user uses. I was wondering if it was possible to force a user to enter some data in a text box on a form, and to not allow them to save or process the work any further until this alpha numeric field...

Hello Everyone I have an Excel macro, which amongst other things applies an autofilter, finds references for a specific entry and deletes the rows with that entry in it. However I would like for that autofilter to be turned off after the deletion has taken place, but I cant seem to get it to...

Can you do the same but for a report?? I have a button that runs a report, but it falls over if the report is still open and it is run again. Does IsLoaded work for a report too, so that you can say If Report is open then close report and run report again, otherwise just run the report

thanks to all all sorted now :D

ta Gary, The only email sample I could find though was yours, and the attachment was still pending approval. Is there any in there in particular that could be of help. Ta for the taking the time out to help Mav

Hello, This is something quite similar to something I am working on at the minute, where I want an email to be generated from a text box. I have no code training at all, so I am trying to just work my way through it. I am not bothered who the subject is, nor the subject title. All I want is...

Hello Everyone I have a question which hopefully someone can help me with. I have a database that links into an Outlook email account. I get the information across via File => Get External Data => Link Tables. However the issue I have is assigning some kind of autonumber to this table. I am...