Microsoft Access / VBA Forum

hey guys, i have a function that can recognize a space character in a string... how can i get it to replace a space with a underscore character Public Function RemoveSpaces(strInput As String) ' Identifies spaces in a string of text If InStr(txtEmail, " ") = 0 Then msgbox "Spaces are not allowed) Else: Exit Function End...

I have a crosstab query which gathers data from a regular table and creates columns for the months in the year with volume for each month. I want to be able export/send the data to a brand new table, which would keep the new formating with the months as fields. So basicall i want to create a table from that crosstab query that looks identical...

This function returns the username of the currently logged in NT User. ' This library must be declared Declare Function GetUserName& _ Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) Function sys_OrigUserID() As String

Within the access code, can I create a new report, or edit existing and cut and paste (or whatever method possible) and insert a word document in to the report detail?

Hi, I was wondering if it is possible (Using access) to have a query parameter as a drop down box rather than a text box? e.g. typing as criteria for a query produces a box with a text box for you to enter the parameter. Can any body enlighten me on how to turn this text box into a drop down box? And whether it is possible?

Greetings. In Access, is there a way to open up a drop-down combobox with keys on the keyboard, instead of using the mouse to click on the down arrow of the combobox? I really prefer to use the arrows on the keyboard and the enter key to make my selection. But if I have to click on the down arrow of the combobox then I might as well use the...

Hi everyone, I have a database with a form on which I have a listbox which is used as a kind of 'menu' (i.e. it lists the titles of all the records in the database). Can anyone help me set up a code so that if I double-click on a record title in the listbox, the form will jump to the corresponding record? I've tried various DoCmd.GoToRecord...

I'm getting intermittent "Object Invalid or No Longer Set" errors in my Access 2002 mdb. What causes these errors? Has anyone dealt with this before? I can't trace it because it's not easy to duplicate -- it just show up... I've heard that spurious queries that use Now() or Date() or some other date

I have created a database and it is used by two people. They rarely need to access the database at the same time. I have created the Database as "Shared" but they are unable to open it at the same time - although I can open the database if one of them are in it. Is this something to do with the network permissions? I have heard about...

Hello Everyone, I was wondering if anyone knows of a way to add a code that would automatically refresh link tables upon opening of database. This is needed due to fact that sometimes split forms wouldn't open due to a lagg and would freak out the user with the error. The fix was to refresh linked tables manually. THanks./ -AF

Hello! All I want to do is have my phone numbers appear (555) 555-5555, but for some reason I keep getting all these weird -- in between the numbers. I read that I should put "(999) 999-9999"! as an input mask, but that didn't work. Does anyone have a suggestion? I appreciate the help! Thanks,

I have a list which is populated with Fields from a table, I want to be able to determine if the data type of the value selected in the list is Number. Any ideas, i thought there would be something along the lines of Me!lstQueryCriteria.Datatype, but my results turned up no dice. The reason I wish to do this is, because I am creating a query...

Hello, is it possible to download files from web site, if list of files is given as full URL, for example: http://www.somewebsite.com/file01.jpg Thank you!

Hi there, Could anyone please tell me how to get the Day (i mean DD from DD/MM/YYYY) from the Date field. I have a created a database for a Loan company. if the Loan Start Date is 20/01/2007, then the due date to pay the interest will be 20th of every month. as of now, i have a field called Due Day where i manually enter the day for each...

For this Tip, we will show you an extremely handy, multi-user, feature of Jet that allows you to manage Users more effectively. You can create a special, provider-specific Recordset in ADO that supplies information about the current Users in the Database. This is accomplished by using the OpenSchema() Method of the Connection Object, which will...

I have a login form. If a user enters the correct username and password I want to open certain forms and close the login form (among other things) when the Sign In button is clicked. I have this code in the cmdSignIn_Click() event: DoCmd.OpenForm "f_Families" DoCmd.OpenForm "f_GiftProcessing" DoCmd.OpenForm "f_Reports" DoCmd.OpenForm...

I'm trying to capture when a user presses a particular key (escape), so I'm coding in the KeyPress event. Yet the code seems be bypassed (breakpoint is never encountered). Should I be coding in a different event? Is this a known issue? FYI, this is happening in both Access 97 and 2000.

Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting : External Data (Ribbon) PDF or XPS (from the Export Group) Select all desired options Publish That's fine, but how to get this done in VBA?

I have been working on a project and one of the things my client wanted was to have a nice formatted duplicate excel spreadsheet of a manually filtered sub form datasheet with all records exported including memo. I at first struggled but have come up with the following code which I wish to share as I know that people will need it for their...

I have an access database, with the default switchboard opening and maximizing on startup. I have put an ON-LOAD event, that opens a pop-up, modal form called frmLogin to ask for username. When the application starts, the switchboard opens, maximises, and the frmLogin form pops up. But sometimes, I don't know why, the pop-up form is not...

Hello group, Somehow, I have not yet fully understood the meaning and purpose of "DoEvents". Can someone post or point me to a clear, concise explanation of it -- one that includes situational examples of how and why it is used? The Access on-line help is not as helpful as I need for my mental density! Sorry to be so dense. Please...

Hi there, I've been searching the net & the forums here over the last few days for help with my problem & am getting myself really confused.. hoping someone may be able to help me here. I've got a continuous form which has 6 textboxes in each row, one of which contains the name of an Assessor, who (in another table) will have a particular...

Hi guys, I have in the past referred to controls on subforms without any issue, however with the new navigation control there does not seem to e a subform to refer to other than NavigationSubForm. I have tried the following: Me!! = Forms!!cmbCustomer Me!! = Forms!!cmbCustomer I have also tried:

Hi All: I was wondering if there's a simple way to call a MS Access Module through either Command Prompt MS Script any other way... Thanks for the response.

The next Access Europe meeting will be on Wednesday 1 Feb 2023 starting at 18:00 (6PM) and finishing at about 19:30 (7.30PM) UK time (UTC) The start time is equivalent to 19:00 (7PM) in Central Europe / CET (UTC+1) and 10AM in Seattle / PDT (UTC-8) For local times, please check https://www.worldtimebuddy.com/ I am very pleased to announce...