Search results

Your function is expecting argument(s) passed to it. i.e. TableInfo(xxxx)

A compile test will show you orphan code. That's as far as i've been able to get, i'm afraid. i will keep an eye out for the answers, though, as i'm in a similar situation.

This may very well be the longest route to solve this problem. Being a beginner, i sometimes suggest things that fall in "the dark side", so someone may come along and tell you so :). One thing you can do is to create a Public variable (you will have to put it in the General Declarations...

It's too quick. Access is still closing the first form when it's asked to delete it. Try doing a DoCmd.RepaintObject or a message box or something to slow the system down a little before deleting the first form.

Hi, all. I have an Access form that needs to be exported into Excel and emailed out from Access. I created an Excel spreadsheet that mimics the form's design and layout, and I can export the text boxes from Access into Excel's cells very easily with the following code: Dim fldDate As...

This did it for me. Thanks! Dim ctl As Control Dim varItem As Variant Dim lstvar As String Set ctl = Me.lstRejCode For Each varItem In ctl.ItemsSelected 'ctl.ItemData(varItem) lstvar = lstvar & ctl.ItemData(varItem) Next varItem Select...

i'm sorry, i don't understand this part at all (or its corresponding code).

Not for listboxes specifically. Thanks again!

Ah, bummer. Let me explain the default values a bit more. The comment field is a memo field because frequently large amounts of text is stored in it, sometimes several paragraphs. This is where the user explains to the end customer why their item was rejected in more detail. Sometimes company...

I have a listbox that lists several possible rejection codes. The user first requested that I put some default language in a comments field based on the value of the listbox, which works fine. Later the user requested that the listbox be able to allow multiple selections. I found that when I...

Apparently the users didn't have folder-level permissions. Since i don't have control over the folder, i created a subfolder that i did have control of and assigned folder-level permissions, and it works well. Thanks all for your help.

Edited to say I found the answer (change .Send to .Display). i had Googled, but not the right combination of terms apparently. Thanks! I have the following code in my database to send an email with attachments. Unfortunately, when it sends the email from MS Outlook, the user's Outlook...

Thanks, but this didn't solve the problem.

I am attempting to create a split database (see previous message) to hopefully resolve this issue, but I have not accomplished this yet. Currently I have one database on a network folder with a primary user (Read, Read & Execute, and Write access through Properties), and a number of secondary...

Both FE and BE are set to Shared on all test users' computers. Thanks!

Using Access 2003. Thanks!

I checked that the FE isn't being opened Exclusively by myself or the other test users. They are not opening the BE directly. So I'm thinking the FE is opening the BE exclusively, but I don't know why or how to fix it. Does that sound right?

I don't have it (the BE) open when I test it (the FE), is that what you mean? Also, if I have the guinea pig open it (the FE) first, and then I try to open it (the FE on my computer), I get the same error. Not sure if that illuminates things.

This seems more likely. How do I check and resolve this? This isn't possible. The users helping me test don't even know it exists (they don't understand splitting, well, neither do I, but I at least understand the concept :p).

The users I have tested with have Read, Read and Execute, and Write access. I also have full control. None of the other users have Modify or Full Control access, but everyone should be able to delete, though it's not a specific property that I know how to look up. I re-split and re-loaded...