Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 127
Search took 0.05 seconds.
Search: Posts Made By: abenitez77
Forum: Reports 11-06-2019, 09:39 AM
Replies: 4
Views: 235
Posted By abenitez77
Re: formatting numbers

This worked! I just had to add a missing comma and parens:

Format(Abs([CreditMemoAmount]), "- $#,###.00")

Thanks!
Forum: Reports 11-05-2019, 03:24 PM
Replies: 4
Views: 235
Posted By abenitez77
Question formatting numbers

I have a report that is using a query where I have a column being formatted in the query like this:
CreditMemoAmt: "- " & CStr(Abs([CreditMemoAmount]))

In the report, numbers like 1,500.00 are...
Forum: Modules & VBA 09-27-2019, 09:00 AM
Replies: 5
Views: 139
Posted By abenitez77
Re: Looping thru all forms

I was using system tables first, but I heard it wasn't good to use them because it is not always reliable...if i delete a form or create one , it doesn't always update the system tables right away? ...
Forum: Modules & VBA 09-27-2019, 06:55 AM
Replies: 5
Views: 139
Posted By abenitez77
Question Looping thru all forms

I am looping thru all forms...and i have more than 1,000. looking for the forms that start with the prefix "DYN_" & MyReportListID. Then when I find one, I am copying those forms and resetting...
Forum: Modules & VBA 04-19-2019, 07:13 AM
Replies: 3
Views: 235
Posted By abenitez77
Re: adodb execution of sql command timeout

I found my answer...I had a window in sql studio where i did a select statement on that table...and it had a hold on the table...so that is why it hung and didn't allow me to insert with tablock.
...
Forum: Modules & VBA 04-19-2019, 07:10 AM
Replies: 3
Views: 235
Posted By abenitez77
Re: adodb execution of sql command timeout

The table is compressed, so TabLock is needed there...so the dba's told me. : )
Forum: Modules & VBA 04-18-2019, 01:26 PM
Replies: 3
Views: 235
Posted By abenitez77
Question adodb execution of sql command timeout

I have this code below and it is hanging on me. It worked fine for several files...but it is now hanging on me and times out with error (-2147217871:Query timeout expired). But When I copy the sql...
Forum: Modules & VBA 02-05-2019, 06:01 AM
Replies: 1
Views: 103
Posted By abenitez77
Re: app hangs

I found my answer...I had to add false at the end of wks.close:

wks.close False
Forum: Modules & VBA 02-05-2019, 05:33 AM
Replies: 1
Views: 103
Posted By abenitez77
Question app hangs

My app is hanging when I try to close an excel workbook. I am linking an excel file and when I am done processing and want to close the workbook, the app hangs. What am I not doing right?

It...
Forum: Modules & VBA 01-30-2019, 11:42 AM
Replies: 10
Views: 106
Posted By abenitez77
Re: Import Excel Files

Now I'm having formatting issues. The date fields are coming up as integers and a column that has long numeric values are coming up as scientific values. How can i get them to insert into ms access...
Forum: Modules & VBA 01-29-2019, 08:33 PM
Replies: 3
Views: 73
Posted By abenitez77
Question Re: set order to columns

Thanks, It gave me an idea and I ran this query in Sql server and got my results I wanted.


Select ID, FullImagePath, TabName, xlsFileName, SheetOrder, Row_NUmber() Over(Partition By...
Forum: Modules & VBA 01-29-2019, 05:04 PM
Replies: 3
Views: 73
Posted By abenitez77
Question set order to columns

I need to populate 2 columns :

1) Add a sequential record number (ClaimRow) that resets for each xlsfilename. This will contain the row number within the xlsfilename.

2) Add a sequential record...
Forum: Modules & VBA 01-29-2019, 04:53 PM
Replies: 10
Views: 106
Posted By abenitez77
Re: Import Excel Files

Sorry, I did not want to come across that way. I do appreciate your help. thanks, i did learn a different way of doing the same thing.
Forum: Modules & VBA 01-29-2019, 01:32 PM
Replies: 10
Views: 106
Posted By abenitez77
Re: Import Excel Files

Found it...setwarnings false. Code is running, but the speed is not anything better with the query instead of linking the excel file.
Forum: Modules & VBA 01-29-2019, 01:11 PM
Replies: 10
Views: 106
Posted By abenitez77
Re: Import Excel Files

nevermind...i reran it and it's fine. Only thing now is that it prompts me to create the table..or insert into the table. How can i remove the prompts?
Forum: Modules & VBA 01-29-2019, 01:03 PM
Replies: 10
Views: 106
Posted By abenitez77
Re: Import Excel Files

Sorry for late response. I got busy on another project. I tried this below and it is leaving out the first row which has the field names. I want the field names to be part of the data. They are...
Forum: Modules & VBA 01-25-2019, 02:01 PM
Replies: 10
Views: 106
Posted By abenitez77
Question Import Excel Files

I am looping thru and linking excel files. Sometimes there is data with the top row having title names. The problem is that when the column names are like "date" and "quatity" then when it links in...
Forum: Modules & VBA 01-21-2019, 12:20 PM
Replies: 3
Views: 134
Posted By abenitez77
Re: dynamically remove recordsource

Excellent! just what i needed. thanks!
Forum: Modules & VBA 01-21-2019, 11:29 AM
Replies: 3
Views: 134
Posted By abenitez77
Exclamation dynamically remove recordsource

How can i remove all recordsources from all forms and subforms in my app? I want to do this with vba to loop thru all forms and remove all recordsources.

thanks!
Forum: Modules & VBA 04-11-2018, 04:46 PM
Replies: 5
Views: 293
Posted By abenitez77
Re: save with question mark in name

The original file has ? in the name. I am only making a copy of the original and need the name to be the same. I can open the file and it has chinese letters in the spreadsheet.
Forum: Modules & VBA 04-11-2018, 03:43 PM
Replies: 5
Views: 293
Posted By abenitez77
Question save with question mark in name

I have a process that runs thru thousands of files and in the end of several steps it saves the file to the z drive. I ran into a problem when it tried to save a file that has a ? in the name. I...
Forum: Modules & VBA 04-05-2018, 08:30 AM
Replies: 10
Views: 686
Posted By abenitez77
Re: conditional formatting

form has no other code. Not sure why it does not save.:banghead:
Forum: Modules & VBA 04-04-2018, 12:16 PM
Replies: 10
Views: 686
Posted By abenitez77
Exclamation Re: conditional formatting

No Cigar... Tried this below and didn't work:


DoCmd.OpenForm FormName:="Form2", view:=acDesign
Set frm = Forms!Form2

Call AddFormats(Forms("Form2")!p24_dmg, frm)


...
Forum: Modules & VBA 04-04-2018, 11:47 AM
Replies: 10
Views: 686
Posted By abenitez77
Re: conditional formatting

I ran this code and it did run successfully, but did not save the conditional formatting.
Forum: Modules & VBA 04-04-2018, 10:39 AM
Replies: 10
Views: 686
Posted By abenitez77
Re: conditional formatting

It will run every time and still not save it. I want it to run once and save so that it doesn't run each time I open the form.
Showing results 1 to 25 of 127

 
Forum Jump



All times are GMT -8. The time now is 10:43 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World