Search results

I have a query that has two columns one being an Old Cost Centre and the other being a New Cost Centre I have a form that has two ComboBoxes and then a TextBox that is populated by the concatenation of these two ComboBoxes this is the Old Cost Centre in the above query I have an additional...

Hi I am trying to create SQL within a sub that uses the sum of three elements in a table and the current date but I then want the name of the table that these entries relate to to be inserted into the table also so the Totals for a table called C5_1 would show in the table as: BWS Date...

Hi there Hopefully someone can help me. I have a situation where I am using a maketable query to create a table and then I need to use append queries to then add additional records to the created table - some of these are just run once and some multiple times. if possible, I do not want to...

Hi I wonder could someone help. I am after creating a list box that will display some of the tables within my database - there are between 10 and 15 tables and the names all follow the same pattern (They all start "tblD10") It is probably something simple but I am not getting my head around...

Hi There Hopefully someone will be able to help me. I am importing a set of tables to a database every month, I then need to extract data from these tables but each month the make up of the columns could be slightly different. The constants are as follows: The first 5 columns are always the...

Hi Hopefully someone can help I have a main form populated by Dlookups. When I click on a textbox I open another form which is used to change data in my main table. Once this is closed the main form is still displayed but the amended data isnt reflected in this form. How do i get the data...

Hi I am importing a spreadsheet on a daily basis that has the same columns in every time but depending on the company I am importing it for different columns will be blank and not needed each time. What is the best way of detecting and removing blank columns Thanks Rich

Hi Hopefully someone can help me. I have a form and I am not sure of the best way to populate the multiple fields on it. The form consists of a textbox to select a date (txtDate) and then once this date is selected I want the multiple textboxes on the form to be populated from data I have in...

Hi I am working on a database for a friend of mine who has a hairdressing salon and I have created an appointment form which basically has boxes for each time slot for each of the 4 stylists that work in the shop. I have built in functionality so that when I click on a blank appointment slot...

Hi I am trying to send an email from a form in Access 2013 using fields on the form as part of the email body and I can't seem to find code to just do this. I don't need to loop through tables as the send email address etc will be on the form together with appointment times etc Is there...

Hi Hopefully someone can help. I am trying to use dsum to calculate a sum from either a table or query to display on a form and this needs to be for different services within a period so I am using the following: Me.txtTotalEarnings = DSum("Price", "KatiesPeriodTakings", "AppDate" >=...