Search results

That was it... thanks for pointing me in the right direction!

Hello, We have a small office network with just a few computers. Computer X has both the front end and a SQL server back end. All computers on the network use this front end MDB. All of this works fine as it has for years. Here is the problem....we recently got a new computer to replace an...

Hello, A couple years ago I found a piece of code for setting access database permissions using VBA (doc.permissions = dbSecFullAccess) I would like to change these permissions to read only but I can't find a list of optional parameters for the permissions property. Can anyone point me in the...

The database I am working with is not used by myself but I design and maintain it for another person. I don't own the customer's data so I am just using a back end of sample data for testing purposes. The duplicate key error was only in my sample data and it was an oversight on my part when I...

Thanks for your replies. Finally got it figured out but it had nothing to do with the actual field or field name. Somehow the primary key (Job Number) properties got changed and there was a duplicate record in the table that had all of the information in the record I was working on except for...

On the form, the field [Email] contains a value along with the other fields in the code. However, upon executing the code, rs!Email is null and that's the problem. All of the other fields in the recordset contain the current values from the form fields.

Hey everyone, In my form I have a button that copies the information from one record to another and opens to the newly created record. This is a sample of the code beneath the button: Dim rs As Recordset Dim db As Database DoCmd.RunCommand acCmdSaveRecord...

That's what I was looking for. Thanks :)

Hi all! I am looking for a little advice on a query. Here is the situation: This database keeps track of calendars of many bands performing at many locations. What I need to do is find all occurrences of what we call "double bookings" or venues that have duplicate entries of bands on the...

Left$([MyField], 7) would keep only the first 7 characters... If you want to eliminate the first 7 characters: =Mid$([MyField], 8) If you are displaying this in a text box, you put it in the control source property of the text box. Good luck

Excellent. Thanks for that link. I did find that page previously from doing a search but all of the text was in another language so I didn't know what buttons to click to purchase a song. Thanks for all of your help!

Yes, I am familiar with iTunes and have it installed on my computer and there are a number of Soulsister songs available in the US but the specific one I'm looking for isn't. The songs in the iTunes Belgium store are only available to members registered from that region so even though I can...

The reason is that I'm looking for a specific song that is not available anywhere in the US but I did find it on iTunes Belgium. It's called "Heaven Sent You Here" by Soulsister. Thanks.

I'm looking for any user here who has access to iTunes Belgium. Please PM me if you do. Thanks! :)

Well there are 36 fields in this table so I was hoping there was a simple workaround for INSERT INTO Table1 SELECT * FROM Table2 Rather than INSERT INTO Table1 (Field1, Field2, Field3.......etc) SELECT Field1, Field2, Field3.....etc.... FROM Table2

If I want to append records from one table to another but some of the primary keys are duplicates even thought the record data is different, how do I do this short of selecting each field separately in the SQL? In other words, I want to append all fields except for the primary key, because the...

Thanks for the links. The problem was a missing primary key. I was not aware that the primary key did not transfer over when you use a make table query.

I have been creating a version of our database for laptop use which would have a standard mdb back end as opposed to the SQL server back end we have in our building. I have it working fine except that there is one query which has 4 joins within. When I use this query with the mdb back end it...

I think it might be fixed... I tried the first link which explains how to change a registry value regarding autoplay. When I did that, my registry key already contained that value so I changed it back to the default value and rebooted. Still no change, so I went to the registry and changed it...

There is an accidental 8 in that first URL. I will check that out tonight when I'm at my home computer. Thanks again!