Search results

Thought I solved it but was wrong. I had inadvertently exported the "local" table to the SQL side and of course it worked from there. Ah well, any other ideas?

Access is 32, server is 64

Hello all, I am sorry if this question has been answered, but I have had no luck finding a concrete answer to this question. Or I am not asking/searching for the question the right way. I have 3 text files, I receive daily, that I need to import into my database. Until we upsized to SQL, we...

Good morning folks, I actually ended up solving this yesterday evening. The over simplified explanation of what I did: I used a strSQL statement that updated the table, set the value of the box to false, where the ID's matched. ReviewID(main form) and FUID(sub form) are the same number. strSQL...

Good morning all, I have a form that contains a listbox that a user can select multiple items from, and that listbox will then populate a subform with those selections. There is a combo box with multiple outcomes for those selections, in the subform, and all selections must have an outcome...

Smig, I am not sure why we didn't do that in the first place. However, I am neck deep in this already with everything set the way it is. Thanks for the suggestion though, I appreciate it!

MarkK you are a genius! I can't believe I forgot to check that...*sigh* Works like a charm! Thanks again! WillM

I have a list box with a select few records in it that when a button is pressed, the contents are displayed to text boxes. It partially works, but the problem I have is that the loop only picks up the last record added to the list box. I have included the code below, changed some names to...

Thanks for the input! I actually decided to just nuke the 2nd combo box and store the values in a listbox and that worked.

I have a several fields, calculated, that break apart a string of text at every open and closed parentheses. They work like they are supposed to with no errors. However, I want to use the result of this particular field in a combo box to populate another combo box with the other half of the...

Unfortunately, I can't, I apologize. Our fiscal year runs from Sept 1st to Aug 31st, and I have to have the information broken down by quarter. I will keep working at it, thank you for your response!

I am not sure I understand why I wouldn't need the month/year, since the query is looking at rolling quarters, and I have to have the previous 4 quarters when the report is run. I am not an expert, but it seems like that would require changing the query every time I need to run the report and...

Hello folks, hope all is well. I am working on a report that has some special characteristics and I need some help trying to figure it out. The explanation is a bit long, so I apologize in advance. Let's say I have a list of groups of Vendors in a table, complete with VendorID. I have 3 other...

Thanks, I will try that.

Good morning! We have a survey form we are trying to get some information from, and I think I need a loop to get the information, but there isn't a ton of information that I have found for what I need to do. I have a six question survey that has a range of answers and a comments section (I...

Turned out to be a corruption. Had to end up rebuilding several forms and queries...not sure where it came from or how it happened, but we are making progress. Thanks again for the help.

Sorry, I am not trying to be obtuse/cryptic. The report itself has no other code in it in either the unload or on exit, or anywhere else. When I say it crashes, I literally mean it closes all of Access, the entire program. Also, I am able to get two other forms to work correctly with the print...

No code in close or unload of the subform in question, however in its parent form there is a macro(through macrobuilder) to open another form on close. I tried the code you supplied and while it opened the form correctly, upon closing the form it crashed Access to the desktop and prompted a backup.

haha Thanks! 1. No, it opens and closes fine. 2. No 3. Appended - I got one other report to work without crashing using the above method. 4. The message " Microsoft Access has stopped working"..."will restart"...then prompts for backup.

Good afternoon! I am attaching a picture of what I am talking about as this is going to get confusing...at least it is for me. I have a Navigation Form that holds 7 tabs that pull reports or data entry forms. I am trying to get the Preview Selected Record function to pull the UniqueID field...