Search results

For hosting on your own computer you could start here: http://www.howtogeek.com/177129/beginner-geek-how-to-host-your-own-website-on-windows-wamp/ For hosted service, you just need to find a hosting service that covers the basics. I only have knowledge of my own service here...

Maybe do it the other way round. Create a calculated field in your query that calculated the year they would need to enter e.g. EntryYr: FY_Year - 1. The you can just do the [?] in this calc field.

Your query should look like this: SELECT table1.ID, table1.student, table1.mark, table1.Subject, Table2.Grade FROM table1, Table2 WHERE table1.mark Between [table2].[min] And [table2].[max]; Note how there is no join in the query. This is called a Cartesian Product and the criteria ensures...

Example of calendar approach attached. The calendar takes only a few minutes to create in Excel (and then copy/paste) and is a one-off exercise.

I would strongly advised against this approach. Hard coding business rules like this is not good design. For one thing, the OP says the rule applies "for most months". Also, given the OPs example I can't see a rule as such. The first period of 2016 seems to start on a Wednesday. But more...

Don't use a start and end date in your calendar table. Just use a single date field and enter all dates for your calendar. This becomes an easy to implement join. Also, it means you can time slices for any date e.g. quarter. Make sure you don't name any date fields "Date" as this is a reserved...

I've certainly added extra columns to sharepoint lists in a live environment without any issues. When you do this if you are using an Access front end you will need to refresh the sharepoint schema on each user - can't remember the option but right-click on the relevant table links in Access and...

like gasman said, the code I wrote was the wrong way round. Just reverse the references either side of the equals sign.

Then I would suggest that type and category aren't really related directly. They are really related through transaction. It's the transaction that gives them some relationship. The reason I question is because it is unusual to see a circular relationship like this.

Looking at this I actually think you need category in the type table i.e. a category has many types. Is that right? At the moment you have one type has many categories.

In your relationship view you should not relate tblTransactions to tblTransactionCategories. The two tables are already related via tblTransactionTypes. You also need to remove TransactionCategory from tblTransactions as this should be determined from the other relationships. The reason is...

Create a continuous form with the fields that need to be entered into the table. In the header, create text boxes to the fields you want to repeat. Then for the BEFORE INSERT event for the detail section, use the following code Me.TransactionDate = Me.txtTransactionDate...

Empty records DO have meaning in the sense of a set of records. If 14 out of 1000 records are blank, that could easily have some meaning. If you delete the 14 blank records then you have lost that information.

Here's a useful reference: http://access.mvps.org/access/forms/frm0031.htm So in your case I think you just need: Forms![Carriers Main Form]!Address1 = Forms![Carriers Main Form]![Carrier Personnel].Form!Address1 There is not need to use a temporary variable. hth

The logic you have provided in the first post implies to me that you want to set all the fields in a row to null except if any one of the fields has a value of "CT". Put another way, if any one of the value in a row is "CT", do nothing, otherwise set all values in the row to null. The SQL...

I think this has now been cross posted here.

Re: Limit of Row in report Here's one way: - Create a text box in the detail section of your report and call it SeqTxtBox. - Enter the following code into the report's Detail Format event: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) seqNo = seqNo + 1...

No need to loop if you use the count function. No need to re-code a function that already exists.

Can you not just put a textbox in your subform that counts the records (the same way you would sum the records). The just refer to that textbox.

Have you tried using the sort functionality in the report editor. Generally I would not rely on the query to do the sorting. Make the report do the sorting.