Search results

The dbo.224Ongoing does have a unique identifier. I just added it and haven't altered the field yet to PK but it is autonumber. Now using the ID in queries allows me to actually pull the correct data in a query in access after the dbo.224ongoing table has been updated , but does not help in...

Good morning. Was not sure where to post this. I have an issue that just began occurring. views, tables and queries have been working fine and now are not. Here are FAQs: 1. created sql server 2012 table and linked to access 2007-2010 db - call it dbo.224Ongoing 2. created sql server 2012...

Good morning. I could truly use the answer to this. I LOVE Partition in Access query for histograms I am creating, but quite correctly, if there are no "records" falling into the partition, Partition leaves out the range. Has anyone figured out a solution other than in T-SQL? thank you!

So, basically, are you saying that after my 'set strLead code, (of course Dims are already done), I should plug in this code and do away with the rest of mine except for red code for loop (I added) and any other "SETS" I need to set to "nothing" and error handling)? (of course using or...

Thank you for the reply. I checked out that link and it had some really good stuff. I finally figured out 99% of the above. I didn't actually "copy" code, I used and adapted part of the code from "Ken's Examples for Exporting to Excel...." So below is the working code. My only problem is, this...

I am totally at a loss. I have a query in Access that I want to export the multiple filtered versions based on "LeadID's in another table and exported to separate worksheets (per LeadID) using transfer spreadsheet vba. I am asking it to find the PeopleID (autonumber NOT indexed) from the...

I have searched everywhere for help on this. I hope you're my saviors again. I have a switchboard form that has a combo control with lists of reports to be chosen. In the VBA of control, I have a case select. (pasted below). I currently have the code below opening a report (built on a union...

Good morning (for me) KiwiMan! You rock. Here's what happened: You were absolutely right about the Set statement the table name being not consistent. But before I fixed that (always experimenting), I realized that you had inadvertently answered the entire question, as you also wrote your string...

KiwiMan: You were right on with the space before W in both codes Paleez, all the code I looked at I did not see that. Secondly, any guess on the second code. I got the number removed (427) once you told me about the space, but I am still getting this 3075 error. I am thinking I need some...

Here is the error code I am getting when I run the sqlPol update string (2nd code) the number (427) in front of the Where statement in the error code is the Me.sourceID number at the end of the SET statement. The POL# at the end of the WHERE statement is correct also. I'm just not getting...

I give up. Two questions (I'm using Access 2007). One, would you please give me the correct syntax for the below UPDATE code. I am getting a "missing operator" on the WHERE statement. Criteria fields are both text. ("UPDATE [policy changes] SET [Policy Changes].[Legislation ID]=" & Me.SourceID _...

hello. I have tried and tried to get this figured out, looked everywhere, so going to break this down. The big picture is I have a 4 tables (not full names but close) Policies, Projects, Bulletins/Announcements, Job Aids. The DB is designed that you may create a record that is the Master...

Thank you for your reply. I forgot to mention that I split this DB. So I'll do the above in a different backend. I hope that works! I am also thinking about your suggestion via the links. The attachments are not images, but emails and documents, and they already live in another folder on a...

I am revamping a DB in 2007 that was created in 2007. I have updated 4 tables, but with 2 of them, when I add the attachements field to the table, it seems to corrupt the table. Why do I think this? Because when I add the field, and then open the form attached to the table, none of the...

thank you, guys. I absolutely agree, but I inherited this "blessed" DB and couldn't bear to rewrite a bunch of code. I have learned a ton from this Forum so Thanks again for the advice. The spaces are bad enough, but how about that "/"?:confused: I have another problem, but it is not vba...

Awesome. Again, I can't thank you enough for the quick response.

thank you for the quick reply. I use this forum constantly and it has saved my .... a lot. Anyways, being the impatient crazy woman I am, while waiting for your reply, I clicked on other coded buttons and controls, ie, Save, Close, on the problem form and ALL of them came back with the same...

I am beside myself with this. Originally I coded the Docmd.Open code with a string to open to a specific record. Worked beautifully. Today (did not shut anything down) the form will not even run the simple DoCmd.OpenForm "formname" code without getting the below message. I have plugged in...