Search results

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.

That was it!!!!!! I didn't realize this was a status he had and thought it was something apart of the debug process. I guess he didn't have the "" around it correctly. This resolved the issue!!! Thank you so much for the help. Side question can the same executable be used for all local copies...

Question here. When working with this is there supposed to be VBA code here? It almost looks as if this database was created not using VBA but Macros within Access and then converted to VBA. Is this normal? Seems like it can create weak links but I may be wrong on that. The error I keep getting...

HMMM Unable to save as an ACCDE seems as though I have too many Table ID's? It says only 2048 can be used at one time. 28 Reports 21 Forms 24 Queries 16 Tables I did read this error unable to create could also stem from file format. Now I am using Access 2016 and the file format is Access...

Thank you so much for that. I tried to tell the previous "Guru" that I didn't think that was correct. He insisted so in part that is my fault not checking into it further. Now that he is gone I will make these changes and am now certain this should resolve a ton of issues. Thank you guys for...

No they are all accessing this file from the server. Which was why I thought that maybe multiple entries would cause the attached error. User = maybe 5 that actually enter items.. maybe a couple more that just review.