Recent content by BenjaminTheBlue

I have a find unmatched query ( criteria - is not null ) that displays all numbers that are in both table 1 and 2. I have another field 'slot' just in table 1. Is there any way I can update that unmatched query to blank out the number. I cant delete the whole record as I need to keep the slot...

Hi can anyone help me? I have a form set up and the Tab order is incorrect. I have all TabStops set to 'yes' and just simply want the tab order to go top to bottom. I have set Tab Order correctly by dragging and even set the properties on each field to Tab Seq 1-10 in order, but when I shut the...

Reply Yes Just when the database shuts down or it is saved. I need to save it to 2 different domains for contingency purposes, but dont know if it can be done without complicated code. Sory I dont mean a whole new database to be created, just save any amendments to copy 1 and copy 2. Thanks...

Hi there, Would anyone know an easy way to save a database to 2 different places automatically when shut down. Regards Ben

Apologies first, because this is probably something so easy. I have searched the forum 1st, but cant seem to find anything. Problem: - Ive created a Database, containing a few forms linked to a few tables. What I need is a field at the top of each form, that someone can fill in the words...

Thx Rabbie Problem is I have lots of prefix to search on, via a button that runs a query to input text. I need to pull lots of prefixes including 'sy', 'n0' ,'nw' and many more. I really need to be able to put in any starting letters or numbers . If I actually put "like n*" in my criteria, it...

Hiya, Just wondering if someone could help me. I need a criteria search to search just the prefix, or from left to right when picking up a number or text. At the moment when I search on the prefix "n0" the results come back with qn0003 and other numbers similar , when i need it just to pick up...

re Thanks Ray:)

ans Yes, just to edit it and upload a copy of the database. I have the address in the form of www.xxxxxxx.com (where x = name of apartments) , but i need to know how to get into the site. I have the password and can edit it through microsoft front page: - then save the page, but how do i...

I have done a little database for someone so they can keep track of available dates for their apartments in Turkey. They want me to add it to their website so people can look for themselves. I know I should join a beginners web design forum, but can anyone tell me how i actually log into a...

Hi, Does anyone know the syntax of defaulting to the previous text from the last entry in just one field. We log lots of products with different addresses in, but sometimes it will be 10 items per address. Ideally i need a check box, but i will have 2 learn how 2 set one of those up...

Nearly finished my 1st database thanks to the people here. Just need direction on one more thing:- i need to input a "return date" into a field on a form and then click a button to run a query based on that date field to list all carts to return on that date. We always have to put in...

Hello, Could anyone point me in the right direction of creating a database that would allocate a number 1-800 for cartridges when logging them in and then when logging them out free up that number again, but keep a record of returned cartridges. I have tried autonumber, but dont know how to...

I am new to Access and i am trying to create a database to log media cartridges in and out. Just found out my wife is pregnant so i really need this to get my bonus ...... I have most of it set up, but need a way to log carts out and keep a record of them. When i log them in, i have a field...