Search results

Hello, people! I have been looking into google and I have not found it. I have an access database file that I am using as backend with the main (or shared) tables and the local one as frontend. Now I would like to create a table, only the structura, in my backend database. I used...

I forgot to answer you. Thanks for your help. I was very useful.

Here is the picture, I think you talk about. By the way, I meant RecordSource, no RecordSet

Hello, I have a form that its a record set is a join query with four tables and I would like to update one column of the main table. The RecordSet query is: <code> SELECT t.au_control, t.fe_fecha, t.tx_operacion, t.tx_documento_contable, t.tx_referencia, t.tx_descripcion, t.mo_ingreso...

Thanks a lot! Muchisimas gracias!

Hello, people! I have been looking into google and I have not found it. I have an access database file that I am using as backend with the main (or shared) tables and the local one as frontend. In my local database file, I link the local tables to the tables in the server. If I want to know...

Sorry! I did not explain myself. I am not using the format function. when I talk to format, I am talking to the properties of the control text box that I choosed 'standar' with 2 decimals as always do with numbers.

The values are numeric (they come from a SUM) and I formatted them as standard with two decimals. Spanish is my language and I like it but I do not understand why access translate words like 'True' in a boolean column/variable. For example, I did an <txtSql = "UPDATE table SET bo_aps = " &...

I tried that, but as the two numbers are taken as string (12,79 and 27,55), access takes only the integer part. the problem is the that it is expecting a decimal point and in spanish we use comma.

Hello! I created a control text box that calculates the sum of two numeric columns that comes from a query. (the two numeric columns are in text box controls, too). Something like '=[monAhorroAporte]+[monAhorroPersonal]'. Instead I am getting the concatenation of the two numbers...

Well! I got a solution. I do not like it but it is a solution. Instead of changing the query and then do a Requery. Looks like does not work because the Requery works, only, with que query that was used when opening the form. I used a control table (lo_diarios_control) with a periodo field and...

I solved my Requery problem. Instead of changing the sql, I did just one sql changing the where condition: "periodo = [number]" joining a control table that has a 'periodo' field, update the periodo value in the control table and do the Requery. Like this: <code> Dim sql2 As String...

Yes, I tried like image, but still problem with the Requery.

I am using break point and checking the sql and it is correct. Baside that if I close the form and start it again, shows me the last query (qryIzq) that was create. I think I am missing a property that permits me to "Requery".

Excuse me! Instead of using filter. I would like to use Requery. I have this code: <code> Option Compare Database Dim ejercicio As Integer, periodo As Integer, pagina As Integer Dim selSql As String Const qryIzq As String = "co_qry_catalogo_cta_sf_izq" Const izqSql As String = "SELECT...

That's true. I'll try that. Thanks In truth you do not need the pages. You can shrink down the tabs to just tabs and no pages. You are really only using the tab to control the subform.

Sorry! I do not know how you get the same control (subFrmOrdersCtl) and the form on each tab.

Yes! I would like to have 3 subforms (left, right and bottom on each tab. It is the same subforms with the same query, for each tab. The only thing that change is the condition in the query. Now, I am testing with the left subform only.

I would like to have 3 subforms (left, right and bottom on each tab. It is the same subformswith the same query, for each tab. The only thing that change is the condition in the query. Now, I am testing with the left subform only. Here is my code: NOTE: I could not work with 'on click' event...

Sorry! Tab Control