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...

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...

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...

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...

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...

Hello all Is it possible to automate the "analyse with excel" function via a button on a form to export a query or report to excel. I would use the transfer spreadsheet, but I do not want it to export to a particular location, I just want them to open in excel in a brand new workbook that is...

I have a query which is based on other quieries that returns a number in percentages, for example 28.24% (format set in properties to percentage and 2 decimal places) Now I want to run an append query based on this information but when the data transfers across it rounds the data to either 100%...

Hello All Firstly I have been reading this forum for a while picking up hints and tips and am very grateful so big grats and thanks to all you guys for the help The problem I am stuck on at the moment will hopfully be quite simple, but I should point out I have absolutely no skill or knowlede...