hey all.
I used to know how to use access, and now haven't used it for years and I am having trouble getting started.
I wanted to make a journal that I could enter in data of an exercise routine.
But the thing is I have no idea how to get started.
I want to be able to add in a workout data for each day monday - friday (each a different body part).
do I make several tables? or just one?
Here is an example of all the data I want to put in, got a picture here
http://members.optusnet.com.au/~adrianloh01/workout.JPG
I find the excel version is messy and a form would be an easier way to save the data and easier to refer back to. If anyone has any idea's on how to do this thanks!
hello i was looking to know if any one could help me with a problem ive got! im designing an online journal but do no know how to start it or where to look in access to design it!!
Ok, so I've converted the database to 2003, split the database, compacted and repaired, but when I go to make an mde of the fe, the system "hangs" I even let it run overnight with no results. There's no error messages, nothing.... it looks like it creates a temporary database called "db1" but it never completes the conversion. Any ideas? Am I missing something simple? I have a feeling I am.
I'm currently developing an MS Access 2002 application that I'd like to be bilingual.
I'm used to making bilingual stuff but for websites and I find it quite different to do it efficiently when dealing with forms.
Currently, I have tried to use a web technique and convert it for my forms.
Basically, I have a table that holds all my labels, classified by categories and owners, then when I load form, I do some VBA scripting to replace the content of my captions.
and it works...but because I always have to mess with a recordset, it gives me a feeling that its crappy and sluggish.
I have tried saving the recordset in XML and using the DOM to do XPath queries on the document (like I do for a website) but I'm not really used to dealing with the DOM object directly and its beginning to turn in a nightmare to run a XPath query with all those undeclared namespaces and all...
well anyway...all I meant to ask was what *you* do to make it efficiently bilingual ?
We have 4 managers and 16 foreman. Each month a manager is tasked with calling 4 foreman for progress reports.
I'd like to create a simple program with Access to have the foreman assigned to the managers differently each month. It would have to remember the past 4 months so the same names aren't assigned to the same managers. It also has to randomly assign the foremen so the managers don't have the same foreman after 4 months (if that makes sense).
There are posts elsewhere on this forum about the adjustments you can make to Access to improve its performance on a wireless network, i.e. make sure you have XP SP2 and not an earlier version of XP, but the fact is that no programme will perform well on a network if the network isn't performing well. Here are a few things I've learned (the hard way!)
- Use USB wireless adapters, not card type adapters. One of the prime rules of wireless networking is to keep your adapter - and your Router - away from electrical equipment and metal objects, so why anyone even makes card adapters is beyond me.
- Place your adapters/Router as high as possible (above head height is best) using a USB extension lead for the adapters if necessary. Do not put them on or near metal filing cabinets!
- Think about line of sight when placing your equipment. If your Router and an adaptor are just on either side of a wall , opposite each other, the signal may only have to pass through, say, 6 inches of wall. If they are at opposite ends of their respective rooms, however, it may have to pass through several feet of the same wall!
-If there are other wireless systems nearby using the same channel as yours, change yours to a different channel even if the other signal is weaker than yours. Remember that you need to be 5 channels away from anyone else before there is 0% overlap in the frequencies. If you cannot achieve this because there are too many nearby networks, any difference is better than none.
I have a 9 user (each in a separate room) p2p network in my office running a split Access 2000 db. The place looks a bit odd with USB adapters stuck high up on the walls but it works. Only one user has the occasional hanging problem (about once a week) but she's using an oldish laptop with only 256k of RAM and it has to run Norton Internet Security at the same time. Three of the users have the db open more or less constantly, the rest have no problem or speed issues getting in whenever they wish.
Nearly forgot, our Wireless system is standard 802.11g. max distance from an adapter to the router is about 80 feet.
Sorry if any of the above is stating the obvious, thought it might help.
Could anyone out there tell me if it is possible to make the output on an Access form read only. I want to be able to input information as records, but when it is saved I don't want it be able to be altered. Mainly I am saving recipes on a form, and I don't want my children to be able to add anything to a record once it has been saved. Thanks in advance Ken
focking pissed off. i want to add an image to a some forms, the database is all working and that. but when i put a picture in in the design view and then go to view it the whole thing crashs. i nearly lost the whole data base from putting one on the home page, thank fock i had a back up and now ionly have to redo one form as the other one wont open anymore it will just crash every time i try to open it. i have no idea whats going on, i have other images that i put on it before, but i cant put any on now. anyone every encounted this and how do i over come it!
there is a need to make access database (access 2007) accessible over net. I know Access Database is not web based application. So I want to know if there is any way of making it accessible via net.
Is it possible to make a path or a shape in access? I'd like to do some graphical representation of some data and change colors of the shapes based on given values that would correlate to the shapes.
I have a table which has the fields: Agentname,SaleDate,Branch,Sales, Percentage, Comission, Corrections, rent and Total
Total = Sales-comission+Corrections+rent
This table has the name of the agent that made the sale, the branch(location) where he made it, the date, the commission of how much he gets from the sale, Corrections which is various correction that need to be made like a refund and or bonuses, Rent which he pays and the total.
what i want to do is to get access to make me a sheet( a sales invoice) where i can see the sales for a specific agent for a specific branch. agents can work at multiple branches.
so lets say agent A on branch A sold 400 on 1/8, 300 on 2/8 and 500 on 5/8 i want to get a list of all the days from 1/8 till 31/8 and the records of 1/8, 2/8 and 5/8 automatically attached to the correct dates and the rest of the dates should have a value of 0.
I have made a new access 2013 database. I have created a linked table that has imported a substantial amount of data from an external data source, (an Excel spreadsheet). So far no problem. I created a select query that plucked data from the original table mentioned. Again, no problem. Then I decided to create another table, using certain fields only from the select query. Microsoft's guide tells me to start with CREATE, then Table design. I am happy to use just 4 fields from my query, but what I keep ending up with is a table, that, when I double click on it gives me the following:
ID Field1 Field2 Click to add (New)
It is presumably expecting me to enter an ID number and it will come up with some record, but I want a complete table that should show several hundred records.
I am working on a database used in recording device characteristics/test information. The main table of information has dozens of columns for test/part detailed information. When inputing the data for each specific test, many of the info. details are repeated when testing say 20 devices of the same part all at once. Rather than retype every piece of detailed information in every field, everytime, is there an easier way? Does anyone know of a way to make specific fields copy/paste the previous record's information in the fields automatically when a new record is created? Please, if anyone could help or has ANY ideas, let me know...
On my database I have a text box that accepts a map grid that starts with two letters. If the letters arnt within certain perameters then the box turns red and a message box appears informing the user of this. My probem is that I am using a continuous form and if one box goes red, they all go red if the grids are OK. my code is below, can anyone help?
Private Sub Grid_BeforeUpdate(Cancel As Integer) If IsNull(Me.Grid) Then Exit Sub If Me.Text289 = "UK" Then Select Case Left(Me.Grid, 2) Case "ST", "SY", "SU", "SZ" Me.Grid.BackColor = 16777215 Case Else MsgBox "Invalid Biagram for your chosen Database.", vbExclamation Me.Grid.BackColor = 225 Cancel = True End Select End If If Me.Text289 = "Germany" Then Select Case Left(Me.Grid, 2) Case "MB", "NB", "NC", "MC" Me.Grid.BackColor = 16777215 Case Else MsgBox "Invalid Biagram for your chosen Database.", vbExclamation Me.Grid.BackColor = 225 Cancel = True End Select End If If Me.Text289 = "Desert" Then Select Case Left(Me.Grid, 2) Case "NJ", "NH", "NK" Me.Grid.BackColor = 16777215 Case Else MsgBox "Invalid Biagram for your chosen Database.", vbExclamation Me.Grid.BackColor = 225 Cancel = True End Select End If End Sub
i developed a program and i used ms access for the database. i compiled the program i made. the question is, can i install the program i made into another computer eventhough it doesn't have a ms access? because i tried to install but it doesn't work at all. what do i need to do in order to make it work.
I am not sure where to post this so could someone please move it to the appropriate area thanks.
I want to make a graph that will show how many employees are in the company for each year (Going back 10 years and keeping up to date) I have never done this before and our teacher feels that its best if we learn on our own (basicaly he's an idiot).
How do I go about using the pivot chart?
I have made a query which adds up the total number of employees at the current time.. but apart from that I havent a clue. I want the graph to have the years on the bottom and numbers up the side (1,2,3,4,5 etc) and then the number of employees that were in the company during that year will be plotted.
I will use a table that is to be used for archiving to mke the query as it will have all the employees who were ever in the system record.
The table is thus:
Employee_ID Emp_First_Name Emp_Surname Age Emp_Home_Number Emp_Mobile_Number Emp_Address_1 (so on and including postcode) Date_Started Position_ID
I have no idea what to do other than to rename the axes and change the increments, but they are jsut numbers, no dates or anything.
I am having error message when I tried to make my mdb file to mde. The error message is "MS Access unable to create an MDE database". Reading through the help message it says that this problem always occurrs in trying to compile large db into MDE. So what can I do to solve this problem. Also what is MS access memory capacity. thanks
:mad:Is there anyway, I can tell who is making my backups. Is there any thing I can use to find out who is creating a backup. I have sent out emails to the users, but no one will confess who is doing yet. I have 200 users now. I have talk to our IT people, they mention it would take a lot of there time to track it down.
One column is "Unitary Price", another one is "Quantity" and another one is "Tax"
And I want another column called "Total" that shows: Unitary Price*Quantity+Tax*Price*Quantity
Is this possible to be made?? :( I'm a bit newbie to MS Access, so try to explain as most detailed as you can! For example, if I have to write [Unitary Price] between brackets... I tried doing this on the "Default Value" field of the column but I couldn't make it.
I'm trying to make totals in a query, but instead of using all, I need to leave one out, how to do that? for example the table looks like: A 2 3 B 4 6 C 2 5 D 3 5 E 2 3 How can I leave row 1 out? So that the query will look like: 11 19
The MainMenu calls the other 3, when I execute the mde file the only form opened is the frmAddEmployee! it should open the frmMainMenu because this one calls the others....! I've tried several times....the same result!
i'm trying to create a form for data input. When creating a new record, I want to make a field, "Date," to read from the last record and use that value as the default value. This way, I don't have to input the same date in every time I make a new record. How would I do this? Thanks =)
