Search results

The answer to this is probably No. I'm using a combo box to display some names. It's unbound. I'm also putting the first item into the text box area. (and not using dropdown if the count is just 1). It all works as hoped but two highlights appear - one in the text area and one in the list.. It...

I'd like to sent and get an access db to an FTP site to two of us can use the same file. I've found a few things with Google (e.g. https://www.codeproject.com/Questions/321083/Automatic-FTP-via-Excel-VBA-Macro) but can't get anything working. That is, even just to connect. Doe anyone have...

Having trouble getting this code to work. It should add fieldname to HardDrives but just shows error 3420 What have I done wrong? Sub AddField(fieldname) Dim MyT As TableDef: Dim MyF As Field Set MyT = CurrentDb("HardDrives") Set MyF = MyT.CreateField(fieldname, DB_TEXT, 255)...

I have a datasheet Form with a Union Query as it's recordsource. So it can't be updated or edited. But I'm looking for some way to achieve this. My thoughts are to get the table and field target from a click event, update the table directly and refresh the Form But how to edit or add the new...

Is this really possible? I read online it was easy and you just resize the borders But (Access 2019) doesn't seem to work.

U

I wonder if this is possible? DoCmd.OpenForm "frmMain", acFormDS, , WhereClause With Forms![frmMain] .OrderBy = "[MyID], [iCost]" .Hide [A Column called iTemp] <<<<<<<<<<<<<<<< .OrderByOn = True .ShortcutMenu = False End With There is no .Hide but...

I beg indulgence as I try and ask about something I don’t quite follow. It concerns the FilterName passed via Docmd.OpenForm The Filtername here is a just-constructed Query at run time. The forms recordsource is a different (permanent) query. The Form opens showing all the fields in its...

I'm wanting to build the Where clause for Dlookup and Access continues to shut down as I attempt to compose the line. The clause I want is Dac =1446 And aName= "A Story" and (Nz([Location],"")="" I've Dimmed c$ as chr$(34) and have (which is failing) x = nz(DLookup("Location", "Table3"...

When this is generated can you know if advance if the number of rows is 0 and thus turn off Warnings Off? And the error message about being cancelled.

UPDATE Table2 SET Table2.iType = "ABCD" WHERE (((Table2.iType)="") AND ((Table2.MyID)=9) AND ((Table2.aName)="Costs")); If iType is Null will this cause a problem? I was trying to include NZ() or IsNull but the query builder kept reported an error.

Having a bit of trouble opening a Form to a particular record. First tried DoCmd.OpenForm "MyForm", acFormDS, "Station = '" & Form_frmTest!Place & "'" A field Called "Station" does exist with a record Place but that didn't work. It just opened to the first record. So in Form Load event I put...

Gee you can spend hours trying to work this out the simplest thing sometimes. I have a function DoDur in frmMain I want to call from a Module m = Forms("frmMain").DoDur(i) What's wrong with that ? ! Access says Application—defined 0r object-defined error Also I don't get it in the drop down...

A dbl-click event in Form2 should call a Sub in Form1 the close. But Access will not exceute it. It tells me Run—time error '2109': There is no field named 'cboCode' in the current record. And there's not... but why would Access be looking for it ? Should it not just follow the code...

Oops, thought I had this nailed (could swear it did work but not anymore) Forms!frmTest!Single = "ddd" Forms("frmTest")!Single = "Q213" Run—time error '2450': Microsoft Access cannot find the referenced form 'frmTest'. The Form and the field named "Single' do exist.

Can I send a in Forms record source via Property Let ? I think the Form must be opened first but by then its too late. That is, the events where you'd apply Recordsouce are done. Or am I wrong ?

I haven't tried to use a Form header until now, and not getting quite what was expected. Although in looks fine in design view, when opened in Form view the Header section is on top of the detail section. The Form shows embedded pictures with record source a table with image filenames. Wanting...

I tried https://social.msdn.microsoft.com/forums/office/en-US/b45fb1d2-5d4a-436d-91f8-372145eb6733/access-2013-vba-shbrowseforfolder?forum=accessdev But when clicking Cancel, Access just quit. Is there something better and one that lets you add a folder if desired? Many thanks

Can't seem to find anything on this.. and various combinations go to error e.g. Dim df as String, Cd as Date df = "Saturday, 19 Mar 1983" cd = DateValue(df) Whether Sat or Saturday is used, same error. CDate is no better. What would be the correct way to cast a string date including Day to a...

I found this from a Google search Literal strings are enclosed in single or double quotation marks. You can use literal strings just like you normally use a column name in the SELECT statement. The literal string will be displayed in very row of the query result. And this is proven in query...