Recent content by jake7363

The append query is the method I know will work, but I forgot how to create the append query without using the query item from the menu. If I use a starting number of 1000, the query comes up with no records. Fyii, I am trying to modify a table I made a few years ago. Jake

It’s been a while since I've used Access (360), so I'm very rusty. Is it possible to have the autoonumber primary key start from 1000? If so, how? Cheers, Jake

I did find an answer. It turns out, there are a couple of issues with the wizard. First of all, it is not showing the fields in the resident (working) form. Secondly, when it did work (I guess it did for someone at some point), it was leaving out one "=" from the code. Ultimately, from a...

Unfortunately, the db contains personal, confidential, financial information - so that is a problem. What I can say is that there is only one table and the field I am trying to match is an ID field (autonumber) as long integer (Access default). That is the key field. What is the oddest part is...

As best I can tell from my rusty vba, that looks like it. But I am wondering why the wizard is not showing the fields in the form I am making the selection from. I would be less surprised if it didn't show the form to be opened, but this is the resident form on which I am currently working. Any...

Unfortunately, this is not what I am looking for; I don't want to use a combo box, but a button. Thanks anyway.

Hi, It has been a few years since I used Access, so I'm asking your patience.. I am trying to open a columnar form from a tabular form (continuous) using a command button. I used the button wizard, but when I tried to match the key field ("id") in each form, it only showed fields on the right...

Hi, I am a bit confused where I went wrong.... In a form, I have 4 option buttons in a frame, named optLog. The Click Event is as follows: Private Sub optLog_Click() selLog End Sub In the module, the function selLog contains the following: Select Case optLog Case 1...

Perhaps my thinking is skewed or I just plain don't understand, but the reasoning for the tables by the individual months (12 in all). is that it seemed simpler to change the recordsource by the month rather than making filters to sort by the months, which are entered in "short date" format. As...

Hi, I have two tables: tblJan, tblFeb I have 1 form: frmMonth. I am trying to use a command button to change the recordsource to view another month. Here is what I have: Sub cmdFeb_Click() Forms!frmMonth.RecordSource = "tblFeb" End Sub An...

OK, to answer honestly, it was not my idea. The issue is that those instances where a customar makes three purchases at different times, in one P.O. The "person" in charge wants all transactions of all instances under one heading of the PO number. I inherited this mess, and am trying to avoid...

If I would use a custom dialag box, I could test against the data in the dialog box to match against the fields, then...?

To ask a bit further, since there is no predictability as to which field will contain the name based on the Select query, would this logic still apply? If I am asking to show which records contain "John Doe" in any one of the three fields, or all of them, I only want to show the fields that...

Hi, I have a report that has three fields that could each have a the same customer name in, based on a query that asks for the customer name. If, for example, two of the fields show the selected customer, is it possible to hide the third field that has a different customer name in? If it...

re Count within a group I'm not sure I follow - if I use DISTINCT within the query, then I will get only those records for that number, but I want all the records, only I want to count the number of times the jobNo changes. Please explain..