Search results for query: *

I have a user that needs to import a data file. The problem is that I used the transferspreadsheet function in the code to import the data. The import worked fine on my machine. However, on the user's end, her tables show up as "dbo.tmp" where mine just show up as "tmp" in the adp file. So...

I have a cross tab report that sums up some information for me based on quite a few different columns. It displays them by a territory number. My issue is that I also need to show 2 other columns alongside the territory. Is there a way to do this? I have: Terr Count1 Count2 Count3...

I'm not sure what the best way to handle some information I need to capture, so I thought I'd post it to tek-tips and see what you guys think... It's for a database where attendees will be registered. A person will call and register multiple people. Those people need to be grouped together...

I was given the task of providing a report in which I need to pull simple information from a table. To throw in a wrench, my field lengths are all 50 and each field in the report can only be a max of 25 characters. If a data field contains more than 25 characters, the rest of the data must be...

I have a table with a First Name column and a Last Name column. 1/2 the records are incorrect where the last names are in the first name column and the first names are in the last name column. I know it's certain records between 2 ids. Is there an easy way to switch the records? Thanks, Kristen

I have a table of names and a table of certificate numbers. How can I sort the table of names by last name and update their certificate field with a certificate number from another table? The certificate numbers need to be appended in their id order to the sorted list of names. Thanks, Kristen

I'm using the TransferSpreadsheet command to loop through a query and export different names in different tabs. It works beautifully, thanks to advice on this site. However, the font it exports to is Ms Sans Serif, and I would like it to be Arial. Is there any way to change the font when...

I have a simple query where the only criteria is that one field is true and another is false. I have a button on a form which exports that query to Excel and then updates the false field to true. Here is the code: DoCmd.OutputTo acOutputQuery, "Query1", acFormatXLS, , True...

I'm not sure if I'm going about this the right way, but I have two fields called Spkr1 and Spkr2. Both need the same reports run. Is there a way to run the same report based on whether I press the Sprk1 button or the Spkr2 button? I tried setting the recordsource from the form to the report...

I have an Access database where I have now added some functionality to track editing changes, but is there any way to tell who accessed the data before now? The backend data file lives on an NT server. I'm expecting to see a bunch of no's here, but I thought it was worth the shot to ask.

Is there any way to do that? This is why I want to do this: Some people in my company have two email accounts, administered by two different IT groups. The account which we connected over the internet to an exchange server, has had ports blocked so we need to use a POP or IMAP account. I...

This probably seems like a silly question, but can you open VB outside of Access? I ask because I'm trying to add some code to prevent the mouse wheel from scrolling between records on a form. The MS kb article says to create a new ActiveX DLL project in VB, and I don't see where you can do...

I'm coming across a problem I have never seen before... Records are being mysteriously deleted in an Access database. Can records be lost any other way than using a delete command or going to Edit->Delete? I'm not really even getting any error records... I look at the autonumber ids, and some...

I had this in the MS Office forum, and got my answer to do this excel. But, now I have some files with too many records for Excel. Can this be done in Access? An example will explain what i need to do best. This is what I have: Field 1 Field2 100 102 101 103 ---100--- ---100---...

An example will explain what i need to do best. This is what I have: Field 1 Field2 100 102 101 103 ---100--- ---100--- 201 203 205 200 ---200--- ---200--- I was able to move over the ---100--- and so on to another field. I'd like to fill everything blank above the number with...

This is the error I'm getting, and my network connection is just fine. I'm unable to change any code, I get "Can't perform requested operation." I can't repair the database, get the above message. The only thing I changed was add some more code to a form. I thought maybe there was...

Hi Guys - I've been looking through these forums all morning and can't figure this out. All I want to do is send this email to the complete list of email addresses that comes out of my query, but I can only get it to the first one. This is what I've got: Dim EmailAddress As ADODB.Recordset...

I have this code set up to look for duplicate names, which if a dup is found a message pops up: If Not IsNull(DLookup("ID", "[tbl]", "[First Name]='" & Forms![frm]![First Name] & "' AND [Last Name] = '" & Forms![frm]![Last Name] & "'")) Then ...

I've been looking for a few hours for this and can't seem to find what I'm looking for. All I want to do is open a form based on another form - however I don't want to have the form that is opened filtered. So, right now I have stLinkCriteria = "[ID]=" & Me![ID] DoCmd.OpenForm...

I get this error on one particular computer in my office when trying to log in to a website of a company we deal with. Error Opening Data Files: Error 39204 Any ideas how to find out what that error means? I've tried dealing with their web master before and they don't seem to know why I get...