Search results

Hi everyone. I've just started a new role as Database Manager, and have been tasked with identifying problems with their current, 15 year old relational database (4D). Generally speaking it's a contact management database designed for targeting specific business markets for specific conferences...

Hi, I've been given a flat-file database to 'improve'. One field is simply titled 'Room' and refers to a room number in a school. I want to create a MakeTable query that will run through all the records and make a table containing one instance of each room number (for normalizing). Hope that...

I have the following code; Private Sub cmdProof_Click() Dim MyFilePath As String MyFilePath = "N:\Pictures\" & Me.txtBanID.Value & ".jpg" MsgBox MyFilePath Call Shell("C:\Program Files\Internet Explorer\IEXPLORE.EXE", MyFilePath, "", vbMaximizedFocus) End Sub I know the...

I have a form with subform...they are not linked (the form shows the table data directly and the subform shows a query of the table). The subform is set as a continuous form. I want to double-click on the unique field to open that record in the parent form. I have something similar in another...

I wasn't sure whether to post this in the form forum or here, but it's coding related to a form, so here I am. I have a simple form that uses a combobox to select a student. Selecting the student autofills the txtStudentID text box. I have a picture box, and the form has some code; Private...

I wasn't sure whether to post this in the form forum or here, but it's coding related to a form, so here I am. I have a simple form that uses a combobox to select a student. Selecting the student autofills the txtStudentID text box. I have a picture box, and the form has some code; Private...

I'm not sure this is the right place nor am I sure Access is the right application but here goes. I have around 1000 photos of students, and they are named (for example); 05162xxxxx.jpg Where "xxxxx" is a random number. The filenames are in an Excel file, along with the student's name...

It's my understanding of general database practice that an Autonumber field should be used as a primary key in normalisation tables. I realise my understanding could be wrong, and I'm quite happy to change that practice if need be. I have my normalisation tables. For the most part these...

I've been using Access for a fair while now, but have only recently come across the community consensus that designing a table with lookups are "bad". Correct me if I'm wrong, but the only real reason I can find for "in table" lookup fields being bad, is that it's an Access only thing, and...

I have a table filled with computer monitor information (tblMonitorManagement). I had query that uses combo boxes (cboSerialNo, cboRoom, cboDepartment) on a form for search parameters. The query is called qryMonitorManagement_Sub. The results are displayed in a subform...

I've enclosed a screenshot as it tells the story pretty well by istelf. I would simply like to be able to click any item in the listbox (populated from a query simply showing all records in a table). Once an item is clicked in the listbox, I'd like the form to go to that record (this is to...

I have a few search forms that, when search parameters are entered, a continuous subform displays the results (summarised...not all fields show). I want to be able to double click a field in any given record, and have it open in a form allowing editing of the record. I know I need something in...

I have a database (backend - just tables), that stores data for an asset register/call logging application. The frontend is pretty much finished, but I'm having one or two issues that are annoying me. I have a form for logging requests...most combo boxes are filled in by looking at...

I know how to use DCount to count the number of occurences of a particular "thing" in a field of data, but how do you count the number of occurences of a number across a record? For example, I have a simple database to record golf scores (attached). I want to count in the statistics area of...

I have a query that shows banned users (I work in a school). When a student's ban has ended, a tick box is checked in a form linked to tblBannedUsers to show they are no longer banned. The query itself simply queries all records in tblBannedUsers with a username field (UserID) taking search...

I have a database that holds hardware data. It's working fine, but there's a slight itch I'd like to scratch and I'm not sure how. Very simply, I have a table listing printers. I have a search form with combo boxes called 'cboRoom' and 'cboDepartment'. The room and department fields in the...

Kind of related to my other post but a seperate question. I once saw a database where the designers had created a form that at first sight was blank. You could click in any of the many text boxes on the form, enter some data, click a command button labelled "Search" and it would display all...

Hi, I've found some similar issues by searching around here but none have been quite the same as my issue. I have a form that display PC details. It's not set up in any special way and allows additions/edit etc. It refers to one table with all the PC details in it (tblDesktops). We're...

I've been asked to come up with a way (one-off) of renaming over 100 hundred tables. The table are all called "STUD_ADMIN_blah". We need to remove the "STUD_ADMIN_" part of the table name. Is there a nice easy way of doing this without having to physically rename each table individually...

I have a form which I use for call logging. I have created a subform which, when a client reference number is selected from a combo box in the main form, the client details appear (address, telephone number blah). It works fine but for purely aesthetic reasons, I want to make this subform...