Search results

Hi, I have a db which i need to create a report called labels from a table called contacts. The attached photo shows the layout i need for my labels, each label needs to be anew record from the table. How is this possible in access 10? Many many thanks

Hi there, i am trying to do some vba or macro coding but keep getting errors. I want the following If the button in my form is ticked then place in the textbox called "txtYes7" = "7" i tried AfterUpdate on the Box: If me.check7 = yes then me.txtYes7 = "7" please help. Many thanks

I hear, My biggest problem is now that i cant make an append query with a field that has a multiple list box. only the first of the multiple list comes in the appended table! Any ideas of coding needed? Thanks

Sorry i only have access 10

Hi there, i thought that, but if i got rid of the other tables in the query then it worked fine. is it a bug??!!?!?! --------- MS Access has far to many bugs!

I can see that this is only happening once i add other tables to my query, but if i just keep the table i am updating it updates with field from that table no problem!

Hi there, I have three tables: Students Parents ClassSplits In my Students table i am making a field called SDD, with which i want an update query to place in there form that table 2 field and 2 field from Parents table and 1 from ClassSplits. My update looks like this: UPDATE TO...

I fully agree with that, just a shame MS cant sort out some of their petty bugs!

I'm sorted, i imported all the tabled into a new db and then split it and it worked, but i left out what i think the problematic table was. Thanks for that anyway

Hi i have an error Unrecognizable dataBase Format. I cant Delete, split or do anything to my db. Can someone please help! p.s. i searched and was surprised not to find any threads on this, and online couldn't really find a solution.

Hi, i am making a big db that is going to be used by 10 people on 10 different pc's on the network. What is my best option: To just split the DB, and have the BE on the server? SQL - i have never used this and have no idea what to do? Or any other suggestions. Thanks

reason being as i need to create many 1 too many realationships based on this multi field, and you cant create 1 too many on a query!

Hi there, i have a table called students with the following field: Name Surname Address Class I want to create another field in the table called summary where i can create a default for that field to place the [Name] & [Surname] & [address] & [Class]. How would i do this. I have now done it...

Thanks, I hit the thumbs up as that was really good. I added a field in my table VUserName, and placed it in my form, and in the header I placed another box next to the one you sent called txtShowUserName. Problem being in the script under the onOpenForm or wherever you put yours I placed a...

not sure do you want to send the db over

Ensure your relationships partID are all connected correctly, then create a query and insert the two tables, then select the field from both tables you want in your query and that should do it!

I had a similar problem when if had to install access97 on my windows 7 with Microsoft 2010 I kept having trouble the whole time, I found out if you first install the older version and only then install the newer version of MS it is usually ok, and this helped me.

Use an update query, see more: http://office.microsoft.com/en-gb/access-help/update-data-by-using-a-query-HA010076527.aspx

Re: Form Load Error described as "Syntax Error (Missing Operator) in query expression Firstly ensure the query opens by itself from the navigation bar, then delete the query from the form and reinsert it into the form and see if this gives more hope.

Thanks for that, I've been looking into that and just can't crack how Nd what is flying, best for me would be when I find some template somewhere where I can see a file dialog in action and copy the code. Ta