Search results

For now it's fixed, I say for now because I'll keep looking for a better solution :) @neileg I wanted to maintain the one to many relationship on the Users - Assets table because 1 user can contain more assets and not the other way around. I've added a Combobox with as the control source a...

Hello and thanks for the response :) My table structure at the moment is: tblUsers ID - autonumber, primary key, 1 to Assets-Users ID Username - text etc etc tblAssets ID - autonumber, primary key Users ID, number, foreign key to tblUsers Assetname - text etc etc ---- What I wanted to...

Form Problem because of relations ? I made a database to register assets of the IT department, I've made the relationships to be one to many and so that 1 User can contain more Hardware... Now I've made a form which shows the hardware device and in a subform the user, I want to make it...

Well i want it to give the value for every record, not just once

Hello, A very short question: I made this code: Private Sub Form_Current() Me.SMS = "ID," & [PCname] & "," & [MAC] & [Serial] & [Make] & [Model] & ",,,,,,,,,,,,,,,,,,Y,tmnl\ID00xxxx" End Sub It works on a single form, but i need it to work on a continuous form, as it is now it'll put the...

Hello, I've got a somewhat urgent question; When i'm editing in my database other users can't open the database and when they have the database open i can't edit it. Is there a possability where i can make it possible to enable me to edit while others are viewing, something like a developers...

Thanks alot for the help it worked great !!! :D

Well i tried, i've put in the following expression: =If([Packaging_in_progress]=True,[Date_pip]="Date()") It didn't work :(, tried some other expressions, they also didnt work.

Hello, I've some checkboxes in my database wich need to have a date bound to it, so when i check a box that the date on wich it got checked appears, if the checkbox is not checked the date field should be blank. Many thanks in advance..

Hello, I got a little question, I made some reports but the records that i have in the tables/querys. How can i get a report preview of only the record i have open in the form, so that if i print it will only print the 1 report.

I have no clue if this is the same as the question of valley, it's to early. Ok here comes, My department and function select their info from the tables noted under here and store info in the form to the table computer. I succeeded to link two comboboxes --------------- Tables: Departments...

Good day all, I got a quick question.. I got 2 tables Departments: ID Department Functions: ID Function Department_ID They are linked with an one to many relation. Now when i'm making my form i want to have 2 combo boxes, 1 listing the results found in Departments.Department and another...