Database Check?... Can Someone Take A Quick Look Please?
Jun 12, 2006
Hey guys,
I'm having two small issues with my database. The first is, I can't get my drop-down to display content on the Form "frmSearch" under "Cast".
And the second, not really a problem, more of an inquiry... on the same form, is there a way to set a default value in the "released before..." and "released after..." of "(enter year - xxxx)" and have that value not interfere with the search feature if it is left as default?
Any help would be greatly appreciated. I'm very new to database creation and an eager to learn about these things. Thank you!
View Replies
ADVERTISEMENT
May 12, 2005
Does anybody know if there is a quick way of making a database read-only (so no data input OR design priviledges).
Ive had a request to send somebody a database so they can look at the data but not add/amend etc. The only thing I can think of is adding a security workgroup and assigning read only permissions. But this seems a bit long-winded and I wondered if I was missing something obvious like a 'save as - read only' option.
Any ideas.
Thanks,
Adam.
View 3 Replies
View Related
Feb 6, 2006
Hi,
Is there anyway to make the front end of my database standalone? For example, I would like to people to run it who don't have Access installed, what ways are there around this?
View 1 Replies
View Related
Nov 16, 2004
I'm relatively new to this Access thing... and I just finished my first one. Well, not finished, as it doesn't work right! Can someone check it out for me and tell me what I'm doing wrong?
It's a customer database I'm making for my work, and I hope to really impress the boss with it! I have the form created to enter in all the customer info, but tab/enter don't go to the next field... and sometimes all the info will dissapear! Then it will re-appear if I go to enter a new contact!
The file is 560kb, so I can easily email it to anyone who will help. Thanks a million!!!
View 1 Replies
View Related
Nov 4, 2013
I have code working for some workers here ,who used to save excel files in a folder and my databse upload those files into database and then do the rest.I am looking for a code in vba which,on upload button matches the file in table and if the file already exists ,it should not upload again in the table and if it does not exists it should upload . I have attached my code below :
Private Sub Command0_Click()
Dim strcPath As String
strcPath = "O:QA FilesQC ReportingPending Review"
Dim strcNewPath As String
strcNewPath = "O:QA FilesQC ReportingMovedFiles" & Format(Now, "yyyy-mm-dd h-mm-ss") _
& " Excel Files" & ""
[Code] .....
View 1 Replies
View Related
Jul 16, 2015
I would like to be able to check if a db is open and if it is to prevent the user from proceeding.
I use the Access 2013 Runtime. I can check if a db is open by trying to open Exclusively, using something like
Code: [URL] ....
But if the db is already open Not exclusively and I try to open it exclusively it does not raise an error and it allows the user to open the db in Read Only mode.
I would like to be able to prevent this, because careless and/or inexperienced users may open several instances of the db.
Of course, if the db is already open exclusively it does not allow you to open it exclusively another time.
View 5 Replies
View Related
Jun 12, 2015
I'm trying to create a checklist in my access database that can be assigned to different companies. Is there a way to maintain a blank checklist so that we don't have to recreate it every time we start working with a new company?
View 3 Replies
View Related
Jul 31, 2013
My desired output of this is to have a database to allow me to quickly check in and out equipment and personnel using a barcode scanner. I am using access 2013 and started with the asset tracking template downloaded from Microsoft. Where I am hung up right now is adding the personnel check in and out (each member of the team will have a barcode attached to their id) I want to be able to just scan their badge when they show up and again when they leave. At the end I will run a report that shows who was on scene (it is for a search and rescue team) during a certain day or time range.
I have added two new tables one check in and one check out the only fields are firedeptID and CheckIn or CheckOut a date/time field CheckIn and CheckOut Auto populatewith Now(). The first problem is that I think I need to turn off (if possible)the auto creation of a new record every time, when I scan in an ID right now that record gets the time stamp of the last time the new record was created IE.Last week when the last person scanned in and the new record was created. I assume I am going the same type of issue when I start working on checking out the equipment.
View 8 Replies
View Related
Sep 2, 2014
I have been trying to come up with a solution for a problem I am having for a while to no avail. We have a backend database that stores various tables full of data. We then have a custom Excel Ribbon that connects to the database and pulls in the different tables depending on the user selection form the ribbon. Everything is working well on that end. The problem I am running into though is that in the development phase of the ribbon and database we had multiple versions and so there are still some people who are using old versions of the ribbon and therefore not connecting properly to the database. Is there some type of code I can add into the database and ribbon where it checks for a specific version to ensure the user is using the most recent version?
Basically, before any type of query is run to connect to the database the ribbon would have some sort of label on it somewhere and the database would check for that label and if it is correct, the code proceeds and if not a message box appears that tells the user they are not using the most current version of the ribbon and exits the sub?
View 5 Replies
View Related
Nov 4, 2006
hey guys quick one
when creating a table in SQL how do you set a variable to yes/no i tried the BIT command but didnt like that so is there any other way?
cheers guys
View 2 Replies
View Related
Oct 16, 2005
Hey guys, I'm just doing this database and have suddenly realised I dont know as much about MS Access as I thought!
Q.1 - I need to run a query that displays the top 5 records in a table, how would I go about doing this?
Q.2 - In my tables, I have of numerical data like the following...
http://img276.imageshack.us/img276/2695/11ch1.png
is it possible to make a Totals column which automatcily adds up the data in the Fraud, Competition, Loss of data, etc rows? (similar to MS Excel if possible)
View 6 Replies
View Related
Jun 20, 2006
HI
I am creating this bloody db and I have created a form and when I open it, it shows, record no one, what I want it to do is open blank ready for a new bit of info to be put in. I know this is an easy one but im sick of the sight of access this week
With thanks
View 5 Replies
View Related
Jan 17, 2007
Hello
Great website. Does anyone have any information on the leafs (http://a-cholesterol-diet.com/index.htm). I have been looking all over the place but no one seems to have any information or listings of any websites, any help would be greatly appreciated.
Thx
View 1 Replies
View Related
May 30, 2007
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 website? I have the wesite address and the password. Thank you in advance Ben
View 5 Replies
View Related
Jun 5, 2007
Hi all,
I am just wondering why Modules have the name of bas at the start of the name. frmForm and rptReport makes sense but why bas for Modules ?
Thanks in advance,
Mitch.....:confused:
View 3 Replies
View Related
Oct 29, 2007
I just joined and wanted to say hi to everyone. Also, I noticed that the forum runs off my screen.
Anyone else notice that?
melanie
View 2 Replies
View Related
Jan 9, 2006
Hello,
one of tables requires me to store sickness details, the sickness codes are all unique, they do however start with at least one 0 for example code - 000003 Description Stress. When you enter a code access automatically trims of the 0's to leave a 3.
Is there a way to override this im unaware of?
View 14 Replies
View Related
Apr 2, 2007
i am using the following query to make a table. i was wondering if anyone knew a way to have the table be named from data entered into a text box in a different form. so when different people type in different names a new different table will be created. thanks
CREATE TABLE tbalename (First_Name TEXT(20), Last_Name TEXT(25), dob DATETIME, Constraint Employees_PK Primary Key (First_Name, Last_Name, dob));
View 2 Replies
View Related
May 4, 2006
Bit of a newbie so help appreciated.
The system I have developed lists jobs (as in jobs that staff members need to go and do) in different towns and cities. These jobs are set as active or inactive depending if completed.
I need to run a report that allows the user to find active jobs in a particular town. I have made a query and by setting the status field to a criteria of "active" this ensures that all results in the query are only active ones.
I cannot find a way to allow the person running the search to enter the name of the town that they want. This would then allow the query and then report to list all "active" jobs in a particular town.
I have a table containing all the towns so hope I can offer the user running the search a means to either type the name of the town into a box or even better (to reduce typo's) be able to choose the town from a combo box.
Once the town has been selected, the report will list all active jobs in that particular town.
Thanks
Can anyone
View 1 Replies
View Related
Jun 21, 2007
I'm writing a field where it shows a combination of many fields.
For example, when a user types in "abc" in field 1, "def" in field 2, "ghi" in field 3, I will have to combine the three fields into "abc/def/ghi" with slashes in between them. However I don't want to have any slashes at the front or at the back the field.
There are unlimited fields of "abc" "def" "ghi" "jkl" "mno" etc. Any idea how I can write the code? I'm thinking using if statements. Is there other ways I can do this?
Thanks!!
View 9 Replies
View Related
Feb 12, 2008
I know I should know the answer to this but if you are creating a query that includes individual fields as well as calculations based on some of those fields, do you select the source field or the query "field" when using the expression builder?
View 5 Replies
View Related
Apr 22, 2008
Hi,
I have a database showing car details, and need to show all records whose MOT is due within the next 30 days/one month (from today)
It might be similar to my first question.
Thanks in advance
Dan
View 4 Replies
View Related
Nov 24, 2004
My Mgrs. have asked me to set up a spreadsheet to keep up with inventory for a certain section of the business. And I figured that in the long run it would be easier to set up a database instead of a spreadsheet. We have specific customers with specific products to keep together; and I have figured out how to fullfill this .... my problem lies with the actual inventory.
The questions:
1) Can I keep an Available tally for all products?
2) To ship out and receive in cargo do I need to make 2 tables or just 1?
I have to keep up with the location of the goods in the warehouse and I'm not sure if I should include that with the product table or a seperate inventory table.
I am not sure if I will be using the database to create 'orders' or what we call bills of lading to ship out the cargo so I'm a little lost on how to keep up with the quantity of each product in the warehouse. There is no 'reorder quantity' or anything like that. I just have to keep up with how much of each product I have in the warehouse. Then I also have to be able to keep track of what is received into the warehouse and what is shipped out of the warehouse.
Does any of this make sense? I'm so confused myself that I'm not sure that I am able to explain what I need or what my questions are without confusing any one I'm speaking with.
View 4 Replies
View Related
Jun 26, 2014
how can i make a image appear in my form when there is a check in the check box from the table?
View 14 Replies
View Related
Jun 15, 2005
Hello everyone, I am new to the forums. I need to learn Microsoft Access very quickly, but I do not understand a thing! I have a list of features of Access that I need to learn: what they are and how to execute them. Could anybody help me please?
The features include:
Field-type
Field-insert/delete
Query – create using criteria
Record – insert/delete
Sort-simple
Structure – file/table
Objects types
Form – columnar
Form – tabular
Form – header/title
Report – create
Report – query report
Filter
Thanks
View 3 Replies
View Related
Apr 1, 2007
I'm importing a rather large CSV file that has many employees, repeated on several lines (one line per day) that contains performance information.
If I want to create a separate table that will contain basic information about each employee (for inclusion on reports), would that be accomplished with a relationship?
I can setup a query to pull up the information by employee name, but I of course receive more than one row since on the import an employee can be listed several times (multiple rows).
The two tables would not share any data, I just want a setup so when a report is generated and a specific employee appears, this information is generated with it. Thanks :)
View 3 Replies
View Related
