Search results

Hi Dave I realise what I have done now. That example I gave was just that an example the column names aren't DED1, DED2 etc they have individual names say Chapel, Medical, PHI etc I only attached the tables to show that it could be a different number of columns each month Is there a way of...

Sorry Dave I see that now - should look before I leap Thanks for this Rich

Hi Dave Thanks for this will go an try it now. Each table will always have the same first 5 columns which apart from the identifier I wont be using and the same last column which I won't be using. Is there any way to get this to start at column 6 and end at last column -1 ? Rich

Hi There please see below example excel spreadsheets that would mirror the tables in access: Month 1: Has 3 columns after the standard Month 2: Has 4 columns after the standard so each month the tables can have additional or less columns and I want a query that will get the data from the data...

Hi There Thanks for the reply - I dont want all columns I just want the data from the columns between the constant columns I will use one of the first 5 columns as it has an identifier in it then i want to get the data from the columns that are between the two sets of constant columns - If I...

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 Mihail The problem is that the code will change depending on which textbox is selected so I am currently selecting textbox txt10800 and that fills a time of 08:00 if I selected txt10830 it needs to fill a time of 08:30 and so on So surely moving the code to the open event wouldnt work as...

Hi Mihail I have tried that but when I do that the code that I use to part populate the opening form doesn't work Here is my code Private Sub txt10800_Click() Dim canc As Integer If IsNull(Me.txt10800) Then DoCmd.OpenForm "frmSty1", , , , , acDialog Forms!frmSty1!txtAppDate = Me.txtDate...

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 Hights the problem is that it can be different columns every time so say the first time I import it could be column G, Column AA, Column BC that are blank and the next time it could be 12 totally different columns Cheers Rich

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

Ok I have now got the code almost to work and it now fills the textboxes on the form but just selects them in order they are in the table even though I thought my SQL was filtering by date. Also it doesnt seem to be putting the correct line in the correct textbox. The code is attached to the...

I think I am getting a bit nearer to populating my form but I am struggling to quite get the code correct. My form is called DailyDiary and I am trying to populate it with records from a query called PopulateDailyDiary. The query has three fields, they are: Textbox - This is the name of the...

Hi Both Each record in my main appointment table is unique in the way you say. I probably didnt express myself well enough. The main table structure is as follows: ID Customer Name Stylist/Employee Appointment Date Appointment Day Appointment Time Service Required Code Appointment duration...

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

Ok I should be able to sort the form How do I now populate the form from a table or query I have a textbox at the top that the person using it can select a date Then each Stylist has a list of textboxes under their name which correspond to times so for stylist one for 8.00am the text box is...

Hi David Thanks for that, is there no way of using the same form for adding and editing the data Thanks Rich

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 Gina Thank you that is working great Rich

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