Search results

I have created a table with a default Day/Time value as Date(). It shows on the datasheet view of the table, but when I create a select query from that and another table, the date field is empty. How do I set a default value in SQL? SQL: SELECT tblClients.ClientID...

I guess I will have to search out some good tutorials on this. I have produced quite a lot of reports, but sometimes it is hard to figure out exactly what Ineed to do with the data to get what I want. I will have to play around with groupings only or subreports a bit more as you suggest.

This is a general question. Of all the objects in Access, getting the right information in the right form on a report seems to be the most frustrating to get right. I look at tutorials, but invariably the tutorials I see cover mostly simple reports, but I get asked to generate reports with lots...

I have a volunteer roster which records volunteers and their rostered days in a table. What I would like to include is an ability to add a field which allows for recurring events such as every week, every month etc. I know that this kind of thing can get very complicated with options such as...

Finally got it! I just needed to use a . instead of a ! in the code. Here is the final code: If IsNull(txtSetRosterDate) Then Me.RecordSource = "select * from qryVolunteerRoster" Else: DoCmd.ApplyFilter "", "[RosterDate]=[Forms]![frmVolunteerRoster]![txtSetRosterDate] And...

That didn't work. Maybe I need to set the recordset for the second stage filter based on the value of cboSelectHub? I'm still a little green as far as working out the code to do that.

Here is the code I have on the OnClick event now: If IsNull(txtSetRosterDate) Then Me.RecordSource = "select * from qryVolunteerRoster" Else: DoCmd.ApplyFilter "", "[RosterDate]=[Forms]![frmVolunteerRoster]![txtSetRosterDate]", "" End If

See if my logic is ok here. I am thinking of something like: cmdSearchDate_Click() If Is Null txtSearchDate Then DoCmd.runSQL SELECT "*" FROM tblVolunteerRoster Else DoCmd.runSQL SELECT "*" FROM tblVolunteerRoster WHERE Hub = Me.cboSelectHub End If Me.requery Is this somewhere in the...

I have a split form frmVolunteerRoster. On this form is a combobox cboSelectHub which allows the user to filter a list of roster dates for volunteers based on their location (Hub). The combobox filters the list fine. I also have a cmdSearchDate button which has an OnClick event that filters...

Yes, you might be right about that. But this project was more for my own convenience than an operational imperative. It is working fine, even though there have been some unexplained non-recorded logouts. The logins are correct, and that's the main reason I put it together. It at least gives me...

Thanks. But I found the problem. I was referencing the field in the hidden form as UserName rather than txtUserName. The silly things we miss!!

I am trying to set up a dynamic logged-in user table where I can keep tabs on who is logged in to a database. I have some of the system working, but the last bit is not working for me. Currently I have: a "frmLogin" with txtUserName and a txtUserID fields. The AfterUpdate event on the...

I have found too that by downloading and working through the templates offered in the standard Access package is a great way to learn. I am still working through Northwind Traders, which is a treasure-trove of opportunity to learn. Also, there are various tutorials based on NWT online. One thing...

Sorry about the late reply. In my case, about 60% of my job is developing and maintaining a database for our operations. I built it from scratch as a rank novice, and built up my skills as I went. At a certain point it began to go from an accessory application for minor tasks to the backbone of...

One other thing I thought of. If you are nervous about users editing tables, make the database effectively "read only" by locking all records, so that queries and reports are only available for existing data. In my case that isn't much of an issue because the users I would give a sandbox version...

Great post! I have undertaken all sorts of training, and mostly I find that I have to work things out myself in the end. Class study is almost useless to develop real-world skills. Like anything else learning comes by practice, practice, practice! And there are some skills most of us will never...

No worries. It's simple. I found another post on this. Set up a "sandbox" private version of the database for each user that needs one, with links to the tables and let them play!

When distributing an Access database, is it possible to make a limited range of development options available to users. For example the ability to generate a query or report, but without access to all of the objects? Obviously splitting the database is important to prevent tampering, but is it...

I have developed a database for someone else, and I need to package it with MS Access Runtime so that they can run the program without a licensed version. I have downloaded both versions of the runtime software but neither will install on my computer. With both versions an error detailing that I...

Thanks everyone on this. At this stage the request is a 'would like to' rather than a 'must have', so I will avoid this for awhile. At the moment I am discussing what exactly their needs are so that we can work out a solution that is as simple and error-prone-free as possible. I'm still...