1,597 Topics
 | |
| | Ok so i have an interesting problem i need some help with. I am a beginner/intermediate user of FileMaker Pro 9 and i maintain a database that contains scanned in files. I am trying to automate the scanning/record making process but to do this i need FileMaker to pull the … |
| | In the expression IIF[SSN]=50,99,[SSN]) when I enter 60, all works well. But if I enter 50, I get "The value entered doesn't meet the validation rule for the field or control". BTW, SSN is defined in the table as Number (Long Integer). What's the problem? |
 | hi ... Need help i need code for backup a database.. i want to place the code in a button... |
| | Hi. Now to start with I'm not asking you to provide me with a solid answer to this, but enough information so that I know where to start looking would be good. I have a project that I am working on which is an Olympic Database. I have several tables …  |
| | Hey All! I'm currently creating a database for a payroll system. I have a table consisting of Occupation_ID (primary key), occupation_description, normal_rate and then 3 different overtime rates. I've created a query to calculate the overtime rates for the different overtime rates, i.e. [code]UPDATE Occupation_Rates_Table SET occupation_rate_overtime_1 = Occupation_Rate_normal*1; [/code] … |
| | Hey all I have another problem with my payroll database. firstly, i've created a form for creating/editing/deleting an employee record, which has relationships in other tables (i.e. a table of hours each employee worked containing the employee number, occupation id and hours worked, etc). When i create a new employee, … |
| | I am trying to automate a process in order to make a monthly routine less time consuming. I have an Excel spreadsheet and an Access database. The spreadsheet contains formulas that calculate values for different fields based on values that are in other fields. The calculation all starts with the … |
| | Help! I can't get in to Access 2007. It's not a database password, but an password for Access itself. I can't even create a blank database. All it does is prompt me for a username and password. I've tried all 10 usernames and passwords of mind but they don't work. … |
| | Ok , maybe i should explain this.... logically i have a form , where i have a drop down list , which lists fields on a table those fields have records on the table, i want to automatically display those records for each field on the form , when you … |
| | Hi all , I am a farmer, macadamia nut farmer. I created all the tables i need too, and set all the relationships. Now: I have diffrents blocks on the farm, each has a name, so i created a table with the names of the blocks as the field headings, …  |
| | I created a switcboard (based on 4 forms) in acces with a close command button on it, but wont close the whole access appliaction if i click on it, please help. |
| | Hi I created an DB, that export data to Excel and create a chart from this data, now I want to know, what can I do to filter data and set a criteria eg. A$2:D$46-range, Criteria =2. The filter is not working if I set that critria, for the data … |
| | Hi Guys, I was just wondering if there's a way of restricting access to the contents of a database by creating a list of users and their corresponding password. So when ever someone tries to open the database a form pops up asking for their user name and password. Thank … |
| | What code can I use to open various PDFs from an Access 2007 form. Each PDF has a different name, which I can save to a variable. I have put the procedure on a double-click of a field. Have tried using GetObject but can't seem to make it open the … |
| | Hi I'm hoping someone can steer me in the right direction please. Attempting to export some access data from a subform into a excel file, however the first four lines of data is OK but the fifth line only sends the first row of data instead of all of the … |
| | Okay I have a database that contains records of billing information. I have created the queries I need to display the information but my issue is, is there a way to take the total values that are being produced from the query and separating them depending on amount for instance … |
| | Hi folks, I have a system for an auctioneer and have on the form I have the fields: lot (the item), reserve price ([Reserve]) and minimum successful bid so far ([Min]). There is then a text box for the user to input their bid ([Bid]). I have set up a … |
| | Hi all... great forum! I'm basically on a crash self-learning course in Coldfusion and database-driven sites, so I'm pretty sure I'm missing some basic concept that would make this an easy query. If anyone could point me in the right direction I'd really appreciate it. This is for a site … |
| | I'm a novice to Access and am learning using Access 2007. I've created my tables and established their relationships. I've created the forms using the wizard. I'm attempting to display summary data on a form but am not having any success. I have a SKU table and form. I have … |
| | Hello all! I hope everyone is blessed and wonderful! I am in a quandry :?: , I have a form that I need certain people (3) to have full rights to edit/update/enter the data and then I have everyone else (approx 40) to be able to view only the information … |
| | Hello, I am trying to analyze 56 years of hourly rainfall data. Right now i have three columns. Date(mm/dd/yyyy), hr(0-23) and hourly Rainfall(inches). I would like to know the count of rainfall events that exceed 2.4 inches in 24 hrs. Meaning if the sum of Rainfall exceeds 2.4 inches in … |
| | Still in a VERY steep learning curve with MS Access 2000 / 2003 Main Table has LastName - HomePhome - MobilePhone plus others of course Some rows will have no entry in the HomePhone field but will have one in the MobilePhone field. I am trying to set Query criteria … |
| | I work here at UPS in the HR department and they use a Microsoft Access mdb database that connects to oracle servers to retrieve tables. It then creates a local copy of the tables and the queries run off that. The tables are updated every morning at 6am by a … |
| | HI im new to the forum and new to access. I just recently took a position with alot of acces develpment involved. My first ques tion is how to pass a value from one form to the next. i want to keep track of what user edits certain records i've … |
| | Im MarcusMaximus. I registered to see if i could get help in access development i never did it in college to the extent i need to do it in work and i am stuck on a lot of things as im now the only person in IT here and nobody …  |
| | Hi! I am trying to use MS access to develope a database which can store "Multiple choice questions and options " as input. And out put shold be taken randomly from the database and it should prepare a word file. But I am a physics lecturer. I have a less … |
| | I gotta make an EpoS system. Does this look right, as a first attempt? |
| | 1) open the table in desihn view. 2)Select the filed u want to alter. 3)Select LOOKUP tab. 4)In display control box,Select Combobox 0r listbox. 5)Under Row Sorce TYpe,SElect Value list. I want to ask that if I select Combobox,Then in Row Source type we select Value List. I want to … |
| | hi , i have problem when my application board (content http client) sending data to database SQL-font. i have try to run the query in PC, it can work, but if my remote httpclient(board) connect to InstantRails server to send data to SQL is not working well.. query: [code=sql]SELECT o1.* … |
| | Hello Everyone, Need help with posting this problem I have with Access 2003. There is no field named contact in the current record. thanks |
The End.