Search results

Thank you.

Could you give me an example of how I would include that in the second function, please?

Thanks pbaldy you pointed me in the right direction. Thinking about it, just like in Access, with VBA, I still need two functions. One to identify the current tournament in the Settings table, because there are other uses for it, and one to get the current tournament date from the Tournaments...

That's what I'm trying to figure out. In Access its just a simple dlookup for GetDefTournament() and GetDefaultTournamentDate(). I want to be able to put a function in SQL Server called GetTournamentDate() that returns the correct tournament date from the Tournaments table. Basically that works...

I have SQL Server backend and Access frontend. Three of my tables are Contacts, Settings, and Tournaments. Contacts is pretty obvious and includes a DOB field. Settings is used for setting default values for specific functions including identifying the current tournament. Tournaments list all...

It occurred to me it may be possible to use data macros to update a LastTransaction field in the Assets table when a new record is added to the TransactionDetails table for that asset. Any suggestions on how to do that are appreciated.

At a client's request I've converted an asset tracking database to a web database. In it I have a web query of all transactions and various details of each transaction. What I need to do is create a report from that query that shows all assets that are currently checked out. There is a...

What I was looking for was a suggestion on how to start it, not necessarily for someone to do it. After all this is a forum where people are usually helpful. In any case I was able to figure it out. Here is the code that works and even inserts the weekday name. Somebody else might find it...

I want to create a form that ask the user for a start date and an end date. Then when the click OK it will append a record to a table for each date and each date in between based on the increment. For example the start date is 6/20/2014 and the end date is 6/27/2014 and the increment will be 1...

Thanks. That did it.

I have a table that includes a date/time field. I want to query that table and show all but the TOP N records. Since the number of records will always be changing I cant do it using the BOTTOM N records. Any suggestions on how I can do this are appreciated.

Any suggestion on how to do that would be appreciated.

At the moment I have a Promotion Details form used to add the new promotion. It is linked only to the promotion table. I use a combo box to select the rank that has been earned. Using VBA on an after update event it auto completes a few other fields. I've been trying to figure out how to use a...

I have three tables: Members, Promotions, Ranks. Members has all the data specific to a member and contains just one record per member. Promotions contains information on member promotions and contains multiple records per member. Ranks is a table of ranks and data specific to each rank such as...

In Access 2007 I've used the Asset Management Database template and customized it for a customer. It has five key tables: Assets, Contacts, Incoming, Outgoing, Transactions. I've made it as simple as I can for the majority of users. Their primary responsibility is when an asset is being...

We're developing a database to manage tournament registrants as well as event results. The key tables we have ar: Contacts Registrations Registration Details Tournaments AgeGroups BreakingAgeGroups ExperienceGroups Events Payments There are queries for using information in the tables to...

I have a table for Registrations and a form associated with it. I would like to have a table for Registration Details. On the registrations form my thought is to have a subform for the Registrations Details. I would like to have the subform have checkbox controls where each control represents an...

Thanks! That did it. I also found that if I set a filter to show records where Barcode is null and set Filter on load to yes worked as well.

I have created a form with a datasheet. When I open the form I see the entire list of existing barcodes. I don't want to see the existing barcodes. The user will just be adding new barcodes one after another.

I have a table of items in inventory. I want a form that shows a blank datasheet to add new item to the iventory list. The user will be using a barcode scanner to enter the item's barcode only then moving to the next new record. Other information for the item is determined by default values...