Search results

You can, in a tbale create your own customerformat for a field. Open you table in design view and select the field you want to edit. In the lower portion of the screen you will see the input mask option. Select this then click to edit the list. Now you can name your Description. In the...

Reez, It may be worth you searching the forum for an explanation of normalisation. A database is very pliable and user friendly as long as it is not treatied like a spreadsheet. Once you go down the road of placing all data into a single table, the point of the database is lost. Q

Can you explain to me what your final goal is. Think I need to work backwards from waht you want to end up with. Q

Hi Reez, Again, remember that the table you have here is not a spreadsheet. The order of your columns bears no real relevance to the storage of your data. Also, it looks like you'd be better off with two table. One for your Service fields and a second for your subservice fields with a third...

Let's say you have a table with four columns. On your form you only want to display two. You can set the recordsource of the for as the table but the more normal route is to use a query. If you create a select query against your table for all fields then create a form with the form design...

Hi Reez, Can't see your screenshot.

Hi Reez, I've posted a sample here to try to illustrate what I mean. Q

Reez, I think you maybe thinking of the table like a spreadsheet. Remember in the table it makes much more sense to have your start and end as two seperate fields in you record which you can then query and display as you choose via a form.

Hi Reez, Bit unclear on this. Can you post a sample of your database and I'll have a look? Q

If your index is againstthe subservice id, that's where your duplicate will be, not in the subservice name. Q

Reez, Hi there. You can't have value, value in a single field in a table. How is your user going to input data? Via a form? What is the purpose of the format you're after? Shout back. I'm sure we can figure it out. Q :)

Sounds like you want DoCmd.TransferSpreadsheet

True true, Kudos to namliam, he's a Jedi next to my Padawan ;)

You could include the months table in your main queries then add a field to the query which holds the name of the resulting month. This would give the month on each line but wouldn't matter if it's going to be the same month all the way through the results for that query. Hope that helps. If...

Hi Dougalsworld, You could add a table with the twelve months in and the mm part of the date in a second field then find the mm part of the reporting month and use the corresponding value in your table as the caption. Q :)

Meant to have a :) on the end. Anyway, hope the answer helps Cheers Q :)

Hi Dave, You could use ,"Activity2Weeks" & " " & Date(), Think that should work. Cheers

Thats should have read in the criterian for time Doh Q :)

Hi Roy, Create a normal select query and in the criteria, place the following >=[Alarm1Time] And <(DateAdd("n",6,[Alarm1Time])) Hope this helps Q:)

Don't know if you're still looking but I'd save the .pdf as text then format and import it. Q :)