Recent content by BC_Seattle

Yeah doesn't look like that is gonna work either. Not sure if it has anything to do with the BE data or whats causing the issue. This thing is growing beyond my capabilities :confused:. If anyone wants to take a look at it I can see if I can send it to you.

Still Puzzled on this one I see there is like several ways to do it and I think I am missing something or just not understanding Ill come back to it later today. Brain is melting. Another way I seen it written out is like this? Any thoughts? Sub Example1() Dim objRecordset As ADODB.Recordset...

Nevermind I noticed the Name has a # in it.

It is but I am reading from a text field. I tried this and still same error. Project ID is also the same as Tracking Number. Could it not be reading it? Like maybe its a query on the form and pulls it from elsewhere? Maybe ill try using the Tracking # see if it makes any difference.

Same error with this one too.

Yes sorry I have added everything to a textbox and a combobox (owner) I am just trying to get it to grab info off the form and enter it to the table. I am not that great with Access.I was voluntold so I am just learning as I go and been trying to research it just finally thought I would ask...

Pic of my table ID is auto number

Same error but doesnt say there is anything wrong with the code.... Which is why I was stumped. I did Add the Single thinking it would need to read as TEXT but didn't work tried several ways. Does it have anything to do with my table?

Ill try the rename of Date I added a screenshot of what I am trying to do hoping that it might help relay

So I have a comment box and you have to scroll all the way to the bottom to leave a new Comment. I am trying to add a new boxes with an Add button that will append the new comment to the Table. I am researching and coming up with this but it errors out. I am not sure if I am doing something...

I did try what theDBguy mentioned and also Between Date() and Date()-30 but for some reason the syntax didn't take. I just needed to get the last 30 days of invoicing. With that I just made 2 reports one for this month and one for last month called it good enough.

Thank you for the help I finally figured out the filter function I was looking for. I got 2 of them one for this month and one for last month. Here is what worked for me: Year([Invoice Date]) = Year(Now()) And Month([Invoice Date]) = Month(Now()) Year([Invoice Date])* 12 + DatePart("m"...

I understand the syntax you have and that totally makes sense. How would I string it together? I assume there needs to be an operation that tells it how and what to filter. I am just not good with Access Syntax to understand it yet. I have taught myself really well on like Hotkey and things of...

I have inherited a database and we currently have a query that pulls all invoices that were completed last week. I wanted to add another report that does the same thing for the last 4 weeks starting as of today. This will help audit anything missed. The code I have appears to only use Static...

Ok that makes it easier on me just wanted to make sure it wouldn't be an issue if they didnt rename. Thank you so much for the help.