Search results

Thank you, so simple when you know how

Hi there Is there a way you can choose what report to run without filling the screen with buttons I have over 50 reports to chose from but do not want a button for all of them. Can this be done with a text box and 1 button? If so, how? Thank you Edd

Ok where do I start I have created the database in access 2016. How do I go about transferring the to a SQL server. Can someone point me in the direction of an idiots guide. Everywhere I look says its in database tools but all I see is sharepoint and split database

CHEERS for that

hi all I wonder if this is possible I have a query that returns multiple results of check boxes relating to week numbers that a task is required. This is invoked by inputting the week number in a form and its frequency. I then have 52 check boxes on my form relating to the week numbers. can...

ok I have got a query to show the results I needed now how can I use the results to update the checkboxes on the form. The results in the query are all checkboxes I would like this to be reflected in the form. On another note I have tried to compile a report from the query (query has 54...

Good afternoon all, I wonder if someone can help me. I am putting a scheduler together and dependant on the week selected and the frequency selected I would like certain week numbers checked. Foe example if I pick week 2 and I put half yearly then week 2 and 28 would check or if I pick week 3...

hi guys, I have created a form that does not show other fields until a certain field is updated (after update). you can only fill these out once the first field is used. the first field is a combobox. My dilemma is that when I recall the form everything is now hidden again and I have to reuse...

The database is 16mb so a bit big but yes I have a field that is filled in automatically when the form is filled in to show what form was used. could you post an idiots guide please as I am really struggling.

No I couldn't get this to work

Ok guys struggling here. I can now open a form from a record woo hoo. but the problem is it only opens one form. What I have I 4 different forms form 1 From 2 Form 3 Form 4 Each form has a hidden field with its name in so that when the database is populated It knows what form the record was...

there is a field that is auto populated with the form name

Hi there I have created a database that is populated from 4 different forms. The database knows which form created what record from a field auto created. I have put a search together in a split form to locate records, now how can I open the record to the correct form it was filled in on...

Cheers guys, now need to know how to create a search box now that can search across all records in the table and display them. this need to also search all fields.

a single form would be ideal but there is different criteria on how a form needs to be presented to different people so the layout needs to change but all of the forms need to be in the same database and if a form is used to fill in the data it needs to follow on from the auto number in the...

thank you for the quick reply, so how can I get the record to change to snapshot after it is saved without doing it manually for example with a button or by pressing new record. with regard to the viewing of the records, at present I can see the same record in all 4 forms but I only want the...

Hi there, I am pretty new to access so please be gentle I have created a database with 4 different forms that are essentially the same apart from a couple of fields. These all need to update the same table as they all need to get there record number consecutively. the problem I have is that...

Hi just a quick hello, forum looks good keep up the good work.