Search results

Hi, I have a database i use regularly and think i have a poor design for what i want to do next but need to work out the best way to make it work in its current setup. I have a table recording enquiries which asks lots of information such as name, phone number, pets, date looking to book... I...

Hi. Just updated my pc to windows 10 and all my standard currency gone to $ and no option of £. I have checked keyboard and it is set to UK so is timezone set and pc set to UK. Any one else had the problem and what is the fix? Many thanks

Hi. Another dead easy simple question! Got a query. Trying to use the sum option. I have records in a table that are showing charges. E.G. 8/12/15 £6 9/12/15 £15 I want the sum to add all these up but using a criteria of between [start date] and [end date]. What i receive when i run the query...

Hi. I have been studying and been off DB's for a year. but getting back on DB'S now!!! Some dead simple help required. I have forgotten how to get data auto input on my form. I have 2 tables. 1 called staff and another called sessions. Table staff has fields~: ID Name Address Hourly rate...

Hi, Does anyone know of a sample database or coding on how to make it that on the first startup of a database on a different pc it requires a activation code which the developer would have to give them? Ideally a different activation code each time. e.g. if they give me a code which pops up...

Hi there, I am about to start creating a db where the client wants me to afterwards make a template which at the click of a button in a form they will be able to select that file and it will directly import it into the correct fields i set it to. Is this poss and if yes can you please advise...

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

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...

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

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...

Hi thre, I have been searching all over on how to create an import button on a form in access 2010 where I can set which table it should copy the data into but the user could locate the import file. NOTE: the reason being I have locked all the ribbons... If necessary I could make a specific...

Hi there, It's my first time trying to work with big imports. What I wanted to do was try and import from 5 excel sheets into one table and merge them into 1 record. E.g. I have pupils with test results for maths, English and ICT. I have 3 spreadsheets called Maths, English and ICT and I...

Hi there, I have attached a db with two tables. I wanted to create a form where you can select multiple values from the table "years" and on a button it would open a query displaying all the records in "students" in those years selected. Please help.:banghead: Thanks

Hi there, I want to create a database that i can save all my passwords in. In the table the password field is set as password and therefore displays "*****". I want to create a form with from that table and put a little unhide button next to the field password saying Unhide password. Is this...

When I insert a new combo that should pull down records in my columnar form, the combo on select will only pull that record up once i have been into design mode or something similar and every time i reopen the form it just doesn't work. Does anyone know if there is a fix for this most annoying...

Please would someone be able to help me out on my sample DB to get the temp vars running, I am having a lot of trouble. My db is in a forum under temp vars, thread 1286451 Ta

Hi there, I have a table [Employees] which has the following Fields - TxtEmpID - StrEmpName - StrEmpPassword Which I use for my login table with the following script: If Me.txtPassword.Value = DLookup("strEmpPassword", "tblEmployees", "[TxtEmpID]=" &...

Hi, I have a .accdb with security where ihave hidden navigation pane and toolbars... Now left with one more thing, is it possible to disable anyone trying to import stuff from my database? Maybe some code or is there a setting somewhere in current db? Ta