Search results

Hello all, I just deployed an update to our FE, and this code throws the error mentioned in the subject line: iFilter = TempVars!tv_SelectedUserDept Me.DS.Form.filter = "[DeptID] = " & iFilter Me.DS.Form.FilterOn = True It has been working fine for a long time. The value filtered...

Hello everyone, Today's question: What is the correct syntax for creating a table with VBA, using an YesNo field, and setting it's default value to NO/0/False? sSQL = "CREATE TABLE TempSupercede (ItemID_FK INT, SupplierID_FK INT, PartNumber TEXT, DiscPart YesNo DEFAULT 0, Supercede YesNo...

Riddle me this: I open a bound form, single table query, with ONE label whose caption is set on load event. The form is opened via a click event on a datasheet, filtered to the ID of the clicked record. The first text box gets the focus, also on load event. Without changing anything at all...

Is it possible to use this: IIF(LEN(txtbox)=3,true,false)) I have not been successful so far. I have a text box that says it has 3 spaces on a report, but the VBA says the length is 0, and not null. I am attempting to combine some contact information into one text box, but only if a first...

I wondering if anyone else has been having a recent problem with Access. I open the FE, something happens as I see a quick flash on the screen, then it closes. Access is not listed on the task manager, but there is an .laccdb file as if it were open. This has been happening just in the last...

Good day everyone - I opened a dev FE today to tweak it, attempting to implement @isladogs Form Resize code. Then I decided to change to overlapping windows...but the Options button/menu was gone! I opened another file and it has the Options available. Any idea what the heck is going on...

Hello, In the last week or so we've been experiencing a ton of errors, and now I am a little stuck in the mud. (And I'm hoping this is not because of an update MS recently put out that interferes with Access! which I read about earlier today.) I've been experimenting with copying, renaming...

Hello all, I have been looking for a solution to this problem... Here is what I would like to do: I have a new DB (DB2), with slightly different design. I want to allow the users to look up materials in the old DB (DB1) and add that to a new order. However, DB2 uses two tables for the...

I am attempting to clean up the data, prepping for an import and removing special characters and accidental user keystrokes... I found this one record, where the user pasted text from a website three times. I got an error about the field being too small, as I was attempting to convert all...

Quick question: what is the benefit of declaring and using a type? Private Type with stuff here... End Type

I have a couple of questions to post here. I am working on a sizable project and would like to be able to switch between Dev mode and Prod mode easily. I am considering creating a table with version numbers and using a module descriptor such as 'INV' for the main Inventory objects. Then, I...

I am working on a re-order process for a new app. I am combining our inventory app with our request for purchase app. Many users have requested a 'click to re-order' function, but with the new setup, I have some difficulties. Attached is a picture of the tables in question. What I am...

Referencing this page: https://www.access-programmers.co.uk/forums/threads/tempvars-vs-type-variables.315649/ May I ask your opinions as to which may be a better option for my database? I am building a program that several departments will use: for inventory, for ordering, logging repairs...

Hello all, I just came across an interesting situation. I open a record form from a list of records, opening it using the docmd method and setting as read only. In the Load event, I disable the subforms until the Edit button is clicked. However, I found out that if I click on the subform...

Greetings, Is it possible to use a variable for the dialog filter, i.e.: strFilter set when the function is called via button click, instead of "*.pdf"? I would like the user to be able to select which type of file they want to add, but the Filters property does not like my string variable...

So I am playing around with ADO connections, and got this bit of code from a book: Microsoft Access 2013 Bible Public Function ExecuteCommand() Dim adRs As ADODB.Recordset Dim adCmd As ADODB.Command Const sTABLE As String = "Users" Set adRs = New ADODB.Recordset...

A good chunk of this code came from Scott L Prince, which is based on code he got from Bob Larson via StackOverflow.com. It has been adapted to fit into any DB I have created so far. The current table setup goes like this: • An admin back end that handles the versioning info, file names...

Hello all, I just split a DB that I had put plenty of time into, and now I cannot open the front end. It is recognized as an accdb file, when I double click or press enter, Access opens to the 'Choose Your File' screen. It shows the file size as 7.25MB, has no password, not hidden or...

Hello All, Why is Today not equal to Today??? So, if I filter a form with a date field, which contains today's date, where "Filter = Date()", it returns the record with today's date. However, if I use a formula to find the last day of the week, and convert that to a datedDate = (Date -...

Hello All, I have one table that is giving me problems. Access is the FE, SQL Server 2014 is where the BE is. I am currently using DAO to access the BE tables. I have one table that gives me an error stating the I cannot make changes because another user is already making changes. I've...