Search results

I've used the DMax method on other applications, but the database I'm writing is designed for multi users so to avoid duplication I opted for an autonumber. Cheers anyway D

Morning everyone, I've noticed a wee problem with a table employing an "ID" auto number field as the only primary key. The table holds six additional pieces of design information for an enginnering application. This table is used in a query to display the data on a split form. I've added...

Cheers Trevor, I'm able to get the form working properly again by importing the backup and modifying to include the addition buttons and code. The bit I'm unclear about is what happened for the colums to be swapped. I'm going to be adding controls and a considerable ammount of code to this...

I've attached a database with the offending form. All the datasheet columns are back to front, namely the Pipe # column should be over on the lefthand side and not the right. I've compared all the properties for this form with a backup copy and there are no visible differances in the form...

Hi everyone, I'm running Access 2007 with Windows 7 and I've run into a problem with a split form where the datasheet at the bottom of the form is now showing the data columns in reverse order with the columns reading from right to left instead of left to right. I have the form orientation...

Cheers for that Matt I'll give it a go. Sorry for the late reply I've been on holiday. D

Cheers smithwick that worked a treat. D

I’m looking to write a common piece of code to get data from a table using the following code: Private Sub MySub_DataFind(My_TblQry As String, My_Field As String, My_Control As String) Dim My_RecordSet As DAO.Recordset, My_DataBase As DAO.Database Dim My_test As String Set My_DataBase =...

Yes I know I did all that and it didn't work. Flipping the database back from overlapping to tabbed and deleting the on open sub routine reset the form and now it will open correctly in pop up format. As I said there must be a bug in 2007, but hay ho you live and learn. Cheers D

Cheers for the advice I tried your suggestion, but it didn't affect anything. I then opened a one week old copy of my database that behaved itself and configured the current copy to the same as the old. I made sure the database's document window was still set to overlapping, but still with no...

I'm have considereable problems trying to get a form I've designed to remember the size I configure. I'm looking for a popup form to auto centre and I want to set its width and height for how it would appear when it is first opened, but each time I size the form and close it the configured...

Cheers for that, I always seem to be tripped up by the exact syntax needed (the help screen were pretty pants), I was so close to getting it to work earlier, but it's very difficult to know if you're heading in the right direction. Still the forum came to the rescue once again. Thanks for...

I’ve got a popup, modal ‘Search’ form that is used to search for a building project id#. Once this number is found a command button can be pressed to write this id# into a textbox of a second ‘Project’ form residing in the background and then close the ‘Search’ form, bringing the ‘Project’ form...

Cheers for that Mike, I don't actually allow access to the query as it's locked. The query is there only for viewing data that can be used by the engineers in other parts of the programme. I was just trying to align the text to improve the look of the query. I guess my form looks a little...

I don't actually have a sub-form saved as a form I have the sub-form object with its source object parameter set to the query listing the data. So in essence I'm showing the query straight up on screen for an engineer to edit the data directly. D

Just to put a bit more flesh on the bones. I've got a child sub-form with its 'Source Object' set to a query which lists the filtered electrical data for a given range of equipment. If I focus on the child form in design view I cannot see any text alignment parameters for the child sub-form...

Cheers gents, It's not essential to align the data to the left but more a point of aesthetics so converting all the data to string values is a touch of over kill. Cheers anyway. If I find a solution I'll drop a post. D

I've placed a sub form within my main form and my query data is viewed from here, but the text is all out of alignment. Is there a option within the query setup to copy the original data format and have all my query data viewable with a left hand alignment? Cheers D

Hi All, I’ve formatted all my tables to display text and number with a left hand text alignment. When I view the table all the data is aligned correctly to the left of each field, but when I display any queries using the same data the fields are aligned to the left for text and to the right...

Cheers I'll give that a go. D