Search results

I inherited a database where instead of a date field, the month, day, and year are in separate string fields in the table. If the dates that I want to filter span the end of one month to the beginning of the next month, how do I write this code: Example dates: 9/25/2022 to 10/1/2022...

I'm hoping someone has some knowledge of this issue. I have an FE and BE. Each workstation (the max using the front end is 3 persons) has the FE on their computer in \documents. My BE is on a server and has 2 databases that the FEs link to. ( I use alot of temptables when possible) one that...

I have a listbox that is populated with a value list. The listbox has 4 columns. Each value in the listbox is its own unique value. Is it possible to click and return a value in a column or row. Example: 5 Tooth Wave 87 tree YY GRF 760 How would I click select a specific...

I have a front end Access 365 and backend sql server database. I get a runtime 3155 when trying to insert a record into the sql table. I haven't found any suitable solution yet. It errors out at rsR.Update. Any help is appreciated. Private Sub cmdAddSelect_Click() On Error GoTo...

I'm hoping someone can help me solve this issue. I have a table with a lot of fields in the same row with similar names the differences are numbers. D1, D2, D3, ...... Chr1Amt, Chr1Code, Chr1Desc, Chr1Dx, . . . . Chr2Amt, Chr2Code, Chr2Desc, Chr2Dx, . . . . And so on. I have been able to run...

I'm not familiar with the sql database structure. I've encountered a sql table that has no apparent unique ID that I can see. If I link to that sql database in an access app, how do I make sure I'm updating the correct row in the sql database. Something about getting the row_number()? sql...

I have a form that I use for my schedule that has 4 columns and enough rows for 8am to 5 pm in 10min increments. Each time slot = 1 textbox on the form. And appointment might take up many timeslots. Each textbox has a invisible associated textbox that holds appt and control data to control...

I have a cmdbutton on Form1 that calls a public function that opens a separate form2 and then populates Form2.listbox. It seems like I've done this before, but this time the code runs but the listbox populates with no data. [Code] Private Sub cmdChartNote_Click() DoCmd.OpenForm...

I'm getting a application crash after I try to stop all code. Private Function Func1() on error goto Func1Err if something then call Func2 Do some more stuff Func1Exit: Exit Function Func1Err: msgbox "Error Message" resume Func1Exit End Function Private Function Func2()...

I have Pervasive Sql v10.30 BackEnd and connect to my Access FE thru ODBC. I have some tables I can open and update records in the pervasive db, but I have encountered a table that when I try to rs.edit/rs.update, says its read-only. I've gone into the Pervasive Control Panel but don't have...

I have some fields that have # in the string representing number such as #1 and #2. I can't seem to find anywhere how to escape the # in an sql? Can someone help me?

I have a Test.txt file that is already open. I want to close it with the following code: Dim objfso Dim objfile dim strfilepath as string strfilepath = "C:\mydir\test.txt" '===Following does not close txt file Set objfso =...

I dont' see much on ssubtmr6.dll so I thought I'd post a question. I have an AccessDb that I've been running for some time (Developed with Access2010). I now recently installed Access runtime 2010 on a Win8 workstation. My application requires ssubtmr6.dll. But for some reason, I can't get it...

I have 3 modules to my user interface that connect to my backend. Each module is a separate front end access accdb. I have coded some buttons to open each of these modules which work well in the developers version. But at runtime, I can only open two of them. The funny thing is this. Say I...

I have a table called [calendar] with text field [month], [day], and [year]. Other fields are 'PID', (the patientID) All of these fields are short text. This table is used for an patient appointment schedule. and each record is a patient appointment that is used to populate a schdule calander...

I'm at my wits end. I have an unbound input form with many text/memo fields that i'm updating to the record. When my code gets to a particular memo field it spits out error 3186 - Can't save record is locked by 'Admin' on machine 'myworkstation'. The interesting thing is that I'm very sure...

I'm having problems with quotation marks in a sql statement. I can't seem to figure out what my problems is. The string is an array separated by a semicolon. 120/80;70;5'6";125 this string represents patient vitals. I'm using the string to update a record. But I get hung up with the...

I have the following code that I used to find an open window so that I won't open it again. I have tracked down somewhere close to what makes MSAccess shut down when the code runs. When it shuts down, no error comes up even though I have error handling. It just shuts down. I placed, in the...

I have the following code that creates a long string that works most of the time but sometimes gets cut short. I can't understand why it does this. When it cuts the string short it cuts it short in the same place. Everything gets in the string up to/or about the following code '</Practice...

I've looked around but can't seem to narrow a search for my particular problem. I want to find out how I can write VBA to find out if a default browser is open to a particular webpage. I guess I'm going to have to find the browsers handle but I also don't know where to go from there. Any...